sql排序问题,为什么怎么排都不对?急呀
30
29
28
..
..
..
17
16
我要上面这种效果
方法一:(不对)
SQLstr="select top 15 ID,add_date from enks_yy where id > 15 order by id desc"
方法二:(还是不对)
SQLstr="select top 15 from (select ID,add_date from enks_yy where id > 15 order by id desc)"
我晕了,要怎么写呀?