sql select first row

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

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

1-- NOTE: This is for Oracle/PLSQL only
2
3-- > EXAMPLE
4select * 
5from CONSUMERS
6where ROWNUM <= 1
7
8/*
9-- > SYNTAX
10select * 
11from {yourTable}
12where ROWNUM <= {number-of-rows}
13
14*/

1In MySQL, top 50 rows are displayed by using this following query:
2SELECT * FROM
3LIMIT 0, 50;