在sql 2000中实现Oracle 中 rownum的功能
select (select count(*) from employee a where a.empno<=b.empno) id,empnm,sex from employee border by empno
在sql 2000中实现Oracle 中 rownum的功能
select (selct count(*) from employee a where a.empno<=b.empno) id,empnm,sex from employee border by empno