[DATABASE/SQLITE] ROWID 키워드 사용하기

icodebroker SQLITE 2024-06-18

■ ROWID 키워드를 사용하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT * FROM Student;

CREATE TEMPORARY TABLE IF NOT EXISTS TemporaryStudent
AS
SELECT * FROM Student ORDER BY StudentName DESC;

SELECT ROWID, *
FROM   TemporaryStudent
WHERE  ROWID LIMIT 2 OFFSET 2;

DROP TABLE IF EXISTS  TemporaryStudent;

1

2

3

4

5

6

7

8

9

10

11

12

13

SELECT * FROM Student;

CREATE TEMPORARY TABLE IF NOT EXISTS TemporaryStudent

AS

SELECT * FROM Student ORDER BY StudentName DESC;

SELECT ROWID, *

FROM TemporaryStudent

WHERE ROWID LIMIT 2 OFFSET 2;

DROP TABLE IF EXISTS TemporaryStudent;