More than 3 years have passed since last update.

Oracle_常用SQL

Last updated at 2019-05-14Posted at 2019-05-14

row_number()

①
select * from
(
select
row_number() OVER(ORDER BY SEQ) as row_number
,ID
,SEQ
,NOTE_TEXT
from
Table) A
where row_number>=1488987

②rownumはoracle default 並べ順の行番号、Orderしていません
select
rownum
,ID
,SEQ_NO
,TEXT
from
Table
where rownum<10

select * from A
where TEXT like '%޼%'