select top 用法

大家好，又见面了，我是你们的朋友全栈君。

access： select top (10) * from table1 where 1=1 db2： select column from table where 1=1 fetch first 10 rows only 取第三行到第5行的记录 select * from (select row_number() over() as row from table) as temp where row>=3 and row<=5 mysql： select * from table1 where 1=1 limit 10 sql server: 读取前10条：select top (10) * from table1 where 1=1 读取后10条：select top (10) * from table1 order by id desc 在sqlserver里面，如何读取按照某个排序，第5到10这五个记录 select top 6 * from table where id not in(select top 4 id from table) oracle： select * from table1 where rownum<=10 取中间记录：60~100

select * from (select rownum r,a.* from table a where rownum <= 100) where r >= 60;

db2 update多行

update table1 set fild = (select t2.fild from table2 t2 where t2.name =table1 .name);

table2 数据要确保唯一性

db2更改表名

RENAME TABLE table TO table1;

db2表结构一样，数据拷贝

insertinto table select * from table2;

db2取最大值的记录

select * from table1 t1 where t1.name=(select max(date1) from table1 t2 where t2.name=t1.name)

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/158586.html原文链接：https://javaforall.cn