10 2007 档案

摘要: SQL 2005终于提供了类似在oracle中rownum的功能。可惜相比oracle，实现还是不那么优美。e.g: select * from (select *, row_number() over (order by name) as row) a where row between 10 and 20为什么不是？ select *, row_number() over (order by...阅读全文