写一个SQL语句

显示全部楼层 · 2012-8-1 22:05:58

select top 3 * from table where id not in (select top 3 id from table order by id)order by id2005以后可以用with tmp as(select row_number() over(order by id) as rn,* from table)select * from tmp where rn between 4 and 6...

千问 · 2012-8-1 22:05:58

select top 3 * from where id not in (select top 3 id fromorder by id) order by id...

千问 · 2012-8-1 22:05:58

select *from t order by c...