Mssql Select Top. To select top 10 records use limit in mysql. The sql top clause is used to limit the number of rows returned.
Its basic syntax is. Select from table limit 100 when using mssql you should use top 100 for example. That you want to select in your query.
The top clause in the statement specifies how many rows are returned.
Also you need to specify limit n after the table name where n is the number of rows you want to select. Its basic syntax is. As we are looking for highest. Now apply select top 5 with ties and any row which has a column value that matches the last rows column value as defined by the order by clause will also be returned in the results.