[SQL Server] 상위 일부만 조회 TOP, ROWCOUNT

SQL SERVER, MSSQL에서 데이터가 너무 많을 경우 일부 데이터만 보기 위해서 다음과 같은 구문을 추가해서 조회한다.

 

SELECT TOP 10 * FROM TableName

SELECT TOP 10 Column001, Column002, Column003 FROM TableName

 

SET ROWCOUNT 10 SELECT * FROM TableName

SET ROWCOUNT 10 SELECT Column001, Column002, Column003 FROM TableName