SQLで連番を振る

1から100まで連番を振るSQL

[SQL Server]

SELECT TOP (100)
ROW_NUMBER() OVER (ORDER BY object_id) AS SEQNO
FROM sys.all_objects

[Oracle]

SELECT ROWNUM AS SEQNO
FROM ALL_OBJECTS
WHERE ROWNUM <= 100

 - 技術 Oracle, SQL, SQL Server