SQL语句:select top 9 * from Products order by Recommend desc; Recommend前10个的值为:15,14,10,9,8,7,6,5,5,5 在Aceess环境中。怎么让只选前9条信息,谢谢帮忙..
SQL语句:select top 9 * from Products order by Recommend desc; Recommend前10个的值为:15,14,10,9,8,7,6,5,5,5 在Aceess环境中。怎么让只选前9条信息,谢谢帮忙..
==============
这句话造成的
可以
select top 9 * from Products order by id(自增id) desc
但我要根据Recommend值排序,然后选出前面9条,怎么实现啊..
谢谢提醒, 加个ID就好了select top 9 * from Products order by Recommend,ID desc