SQL語句練習

標籤：查詢   練習   ...   sql查詢   limit   order by   bsp   語句   row   

查詢21-30條的資料庫MySql查詢select * from table LIMIT 20,10

SqlServer查詢

2.1先根據ID升序 查詢前30條記錄資訊，再將查詢的結果根據ID降序 查詢前20條記錄

Select * from （select top 20 * from （select top 30 * from 表名 order by ID）t1 order by ID desc  )t2 order by ID2.2先將查詢出前10條記錄資訊，然後將這10條資訊從結果集中剔除掉select top 10 * from 表名 where id not in (select top 10 id from 表名 order by id asc ）order by ID先查詢出前10條記錄最大的ID，然後再查詢出>ID的前10條記錄資訊select top 10 * from 表名 where ID >(select max(ID) from (select top 10 ID From 表名 order by ID) t1) order by IDOracle查詢select * from (select rownum no,* from 表名 where rownum <=30 )where no >20 如何刪掉資料重複，僅僅保留一條資料Delet from table t where (t.欄位,t.欄位2,...,t.欄位n)in (SELECT 欄位1,欄位2,...，欄位n from table group by 欄位1,欄位2,...，欄位n having count(*)>1)and rowid not in(select min(rowid) from table group by 欄位1,欄位2,...，欄位n having count(*)>1)  

SQL語句練習