积极答复者
SQL Server 2000 查询某一行的数据

问题
答案
-
--测试数据 declare @T table (id int,value int) insert into @T select 1,12 union all select 2,12 union all select 3,98 union all select 4,12 union all select 5,23 union all select 7,12 union all select 9,11 union all select 11,11 union all select 12,19 union all select 13,23 union all select 14,55 union all select 15,66 union all select 16,77 union all select 23,88 union all select 26,11 union all select 29,87 union all select 30,99 union all select 31,15 union all select 32,9 union all select 35,5 union all select 37,48 union all select 39,29 --对于SQL SERVER 2000来说,我只知道top select top 1 * from (select top 20 * from @T order by id) a order by id desc /* id value ----------- ----------- 35 5 */
- 已标记为答案 Rainrcn 2012年8月19日 8:30
全部回复
-
--测试数据 declare @T table (id int,value int) insert into @T select 1,12 union all select 2,12 union all select 3,98 union all select 4,12 union all select 5,23 union all select 7,12 union all select 9,11 union all select 11,11 union all select 12,19 union all select 13,23 union all select 14,55 union all select 15,66 union all select 16,77 union all select 23,88 union all select 26,11 union all select 29,87 union all select 30,99 union all select 31,15 union all select 32,9 union all select 35,5 union all select 37,48 union all select 39,29 --对于SQL SERVER 2000来说,我只知道top select top 1 * from (select top 20 * from @T order by id) a order by id desc /* id value ----------- ----------- 35 5 */
- 已标记为答案 Rainrcn 2012年8月19日 8:30