In different databases, the syntax of selecting top N records are slightly different. They may also differ from ISO standards.
In SQL Server, use TOP (N) to retrieve the first N records in the table. Remember to replace N with one actual number.
Code snippet
SELECT TOP (N) * FROM TableName;