海量数据排序 请教高手:有80多万条数据,要求排序,并取前百分之二的数据.急!!!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 declare @i intset @i=ceiling((select count(1) from t)*.2)set rowcount @iselect * from t order by col1,col2set rowcount 0 declare @i int set @i=ceiling((select count(1) from t)*.02) --*.02=2%set rowcount @i select * from t order by col1,col2 set rowcount 0 select top(2) percent FROM * ORDERY COL1,COL2 --语法select top 2 percent * from 表名 order by 列名[,列表] asc|desc--示例select top 2 percent * from sysobjects order by id desc select top 2 percent * from sysobjects order by id desc select top 2 percent * from sysobjects order by id desc --id为聚集索引 disticnt 用法问题 SQL触发器可以实现这个功能吗? 怎么样才能使sql mail 支持html发送? nvarchar(20)表示多长? sql2008 无法安装:提示The MOF compiler could not connect with the WMI server. css边框为什么输汉字可以,字母却不行 关于数据类型自动编号的问题,在线等 概念问题 想问一下SQL能实现这样的功能吗?应该怎么实现? sqlserver就是mssql吗/ ------sql2005和powerdesigner12的反向问题----- 在vista home basic上装sql 2000
set @i=ceiling((select count(1) from t)*.2)set rowcount @iselect * from t order by col1,col2set rowcount 0
set @i=ceiling((select count(1) from t)*.02) --*.02=2%set rowcount @i select * from t order by col1,col2 set rowcount 0
select top(2) percent
FROM *
ORDERY COL1,COL2
select top 2 percent * from 表名 order by 列名[,列表] asc|desc--示例
select top 2 percent * from sysobjects order by id desc
select top 2 percent * from sysobjects order by id desc
--id为聚集索引