Answers for "sql get first 100 rows"

how to select first row of database sql

-- select the first row of database table
select * from company limit 1

sql only five first row

SELECT your_column
FROM your_table
WHERE your_condition
LIMIT 5; -- your limit of rows you want to show here

how to fetch first 10 rows in sql

select top 100 * from myTable
select top 100 colA, colB from myTable