¡¡¡¡
ÌÆÉ½ÍøÕ¾ÖÆ×÷ʱÈçºÎ´ÓÊý¾Ý¿âµÚ¶þÌõ¼Ç¼¿ªÊ¼¶ÁÈ¡ÄØ£¿
ÔÚÕâÀïÌÆÉ½³¤³ÇÍøÂç²âÊÔÁËÒ»¸öÍêÕûÕýÈ·µÄSQLÓï¾äÈçÏ£º
select top 10 * from xw where id <> (select top 1 id from xw where xwlb_id=241 order by px_id desc,tjsj desc) and xwlb_id=241 order by px_id desc,tjsj desc
Çë´ó¼Ò²âÊÔһϰÉ
¾¹ýÌÆÉ½ÍøÂ繫˾ ÔÚMSSQL2005²âÊÔͨ¹ýûÓÐÎÊÌâ