SQL语句——显示前面8条？
select   b.*   from   proDD   as   a,product   as   b   where   a.productNO   =   b.ID   order   by   a.orderby   desc

只取前面8条记录，在select后加top   8怎么没反应？

------解决方案--------------------
by a.orderby 是这样吗，你检查语法了没有啊
------解决方案--------------------
…… order by a.orderby desc,a.productNO desc
如果orderby里有N条相同且并列第8，就都算上了。
------解决方案--------------------
select top 8 b.* from proDD as a,product as b where a.productNO = b.ID order by a.orderby desc