TOP:
语法:select top num|percent column_name[s]|* from table_name
作用:取前num条记录,或按百分比返回记录
支持数据库:MS SQL
num实例:
例1.取数据库前5条记录
MS SQL实现:
select top 5 * from customers;
其他数据库对应实现
MySQL:
select * from customers limit 5;
Oracel:
select * from customers where ROWNUM <= 5;
例2:从第m行开始,取n行数据
MS SQL实现:
select top n * from customers where id not in (select top m id from tablename);
其他数据库对应实现
MySQL:
select * from customers limit n offset m;
Oracel:
SELECT * FROM(
SELECT * , ROWNUM AS BEF FROM(SELECT * FROM [TABLE] ORDER BY [ORDER]) WHERE ROWNUM <= (m+n))
WHERE CON >= m;
percent实例
例1.取数据库前50%记录
MS SQL实现:
select top 10 percent * from customers;
其他数据库对应实现
需要使用count配合计算
语法:select top num|percent column_name[s]|* from table_name
作用:取前num条记录,或按百分比返回记录
支持数据库:MS SQL
num实例:
例1.取数据库前5条记录
MS SQL实现:
select top 5 * from customers;
其他数据库对应实现
MySQL:
select * from customers limit 5;
Oracel:
select * from customers where ROWNUM <= 5;
例2:从第m行开始,取n行数据
MS SQL实现:
select top n * from customers where id not in (select top m id from tablename);
其他数据库对应实现
MySQL:
select * from customers limit n offset m;
Oracel:
SELECT * FROM(
SELECT * , ROWNUM AS BEF FROM(SELECT * FROM [TABLE] ORDER BY [ORDER]) WHERE ROWNUM <= (m+n))
WHERE CON >= m;
percent实例
例1.取数据库前50%记录
MS SQL实现:
select top 10 percent * from customers;
其他数据库对应实现
需要使用count配合计算