select * from
(select rownum as my_rownum,table_a.* from(
select distinct checkno from kh_check order by id) table_a
where rownum<11) where my_rownum>=1oracle里试过了可以用,sqlserver不知道能不能用。
(select rownum as my_rownum,table_a.* from(
select distinct checkno from kh_check order by id) table_a
where rownum<11) where my_rownum>=1oracle里试过了可以用,sqlserver不知道能不能用。
selece distinct top 10 checkno from kh_check order by id desc
SELECT DISTINCT TOP 10
selece distinct checkno top 10 * from kh_check order by id desc
^写错了!!!
select distinct checkno top 10 * from kh_check order by id desc
我试过没有问题的
我刚试了
出错提示: Incorrect syntax near '10'.
但问题还未得到解决!
真的不行呀!
select distinct checkno top 10 * from kh_check order by id desc
selece distinct top 10 checkno from kh_check order by id desc
这两个都不行!
我真接在SQL管理器真接调用指令查询,还不行!更不用说用在JSP程序里!
还有一个要注意的就是同一个"checkno"订单号,有多条记录!
请各位大哥再想想办法!
我用SQLServer试了,应该可以!
我现在发现了绝对行的!SELECT DISTINCT TOP 10 id, checkno
FROM kehu_check
ORDER BY id DESC