常用数据库操作比较

1.表查询

-- MS SQL Server
select * from "数据库名"."dbo/schema"."表名"
-- Oracle
select * from "schema/用户名"."表名"@"数据库/实例名"
-- Mysql
select * from `数据库名`.`表名`

2.分页查询

参数：pageNo={1,2,...}, pageSize
-- oracle
start=(pageNo-1) * pageSize+1;//RN从1开始
end=start + pageSize;
SELECT * FROM (
      SELECT ROWNUM RN1478748654848, TA1478748654848.* FROM ( 表或查询SQL ) TA1478748654848
 WHERE RN1478748654848 >= start 

-- MS SQL Server
第一步：获取第一个字段名(未知的情况)
SELECT TOP 0 * FROM ( 表或查询SQL) T1478748780548
第一个字段名：first
第二步：分页
SELECT TOP pageSize * FROM (表或查询SQL) T1478748780548 
    WHERE first NOT IN (
    SELECT TOP pageSize*(pageNo-1) first FROM (表或查询SQL) T1478748780548 ORDER BY first)  
    ORDER BY first

-- mysql
start = (pageNo-1) * pageSize;
SELECT * FROM (表或查询SQL) T1478749978066 LIMIT start, pageSize