ms sql limit code example

Example 1: select limit ms sql

select top 10 column from table;

Example 2: select limit ms sql

-- select column from table limit 10;
select top 10 column from table;

Example 3: How to display top 50 rows?

In MySQL, top 50 rows are displayed by using this following query:
SELECT * FROM
LIMIT 0, 50;