Hi All,

I’m back… Long time anh???… lol

The TOP option is used for limiting the output of a query result set.

— Syntax for returning n number of rows:
SELECT TOP n *
FROM table

— Example for returning 10 rows
SELECT TOP 10 *
FROM mytable

— Syntax for returning n percentage of rows:
SELECT TOP n PERCENT *
FROM table

— Example for returning 5 percent of rows
SELECT TOP 5 PERCENT *
FROM mytable

See u😀