SQL - 참조 - 키워드 - SELECT TOP, LIMIT 및 ROWNUM

SELECT TOP, LIMIT 및 ROWNUM

SELECT TOP, LIMIT 그리고 ROWNUM 명령은 반환할 레코드 수를 지정하는 데 사용된다.

⭐ SQL Server는 SELECT TOP, MySQL은 LIMIT, Oracle은 ROWNUM를 사용한다.

SELECT * FROM Customers
LIMIT 3;

기본 예시

CustomerID	CustomerName	ContactName	Address	City	PostalCode	Country
1	Alfreds Futterkiste	Maria Anders	Obere Str. 57	Berlin	12209	Germany
2	Ana Trujillo Emparedados y helados	Ana Trujillo	Avda. de la Constitución 2222	México D.F.	05021	Mexico
3	Antonio Moreno Taquería	Antonio Moreno	Mataderos 2312	México D.F.	05023	Mexico

SELECT TOP 3 * FROM Customers;

기본 예시

CustomerID	CustomerName	ContactName	Address	City	PostalCode	Country
1	Alfreds Futterkiste	Maria Anders	Obere Str. 57	Berlin	12209	Germany
2	Ana Trujillo Emparedados y helados	Ana Trujillo	Avda. de la Constitución 2222	México D.F.	05021	Mexico
3	Antonio Moreno Taquería	Antonio Moreno	Mataderos 2312	México D.F.	05023	Mexico

SELECT * FROM Customers
WHERE ROWNUM <= 3;

기본 예시

CustomerID	CustomerName	ContactName	Address	City	PostalCode	Country
1	Alfreds Futterkiste	Maria Anders	Obere Str. 57	Berlin	12209	Germany
2	Ana Trujillo Emparedados y helados	Ana Trujillo	Avda. de la Constitución 2222	México D.F.	05021	Mexico
3	Antonio Moreno Taquería	Antonio Moreno	Mataderos 2312	México D.F.	05023	Mexico

W3C School - SQL SELECT TOP, LIMIT 및 ROWNUM Keywords

W3C School - SQL Tutorial

Mingg`s Diary

밍구

공부 목적 블로그