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>=1
很多谢各位大哥的意见!
但问题还未得到解决!
真的不行呀!
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"订单号,有多条记录!
请各位大哥再想想办法!
这位大哥你把
selece distinct checkno top 10 * from kh_check order by id desc
^写错了!!!
select distinct checkno top 10 * from kh_check order by id desc
我试过没有问题的