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;