How do you get records number from 1 to 15 in a dataset of 100 records

You can use TOP Keyword in SELECT statement.

First Sort table data means using order by and write SELECT query

FOR EXAMPLE

SELECT TOP(15) * From Employee WHERE ORDER BY Name