/SQL/How to fetch first 10 rows in sql

How to fetch first 10 rows in sql

SQL SELECT TOP Equivalent in oracal

syntax -> SELECT column_name(s)
FROM table_name
WHERE ROWNUM <= number 
////example///
SELECT *
FROM Persons
WHERE ROWNUM <=5

0

How to display top 50 rows?

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

-1

How to fetch first 10 rows in sql

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

-1

Source: stackoverflow.com

Similar codes

0 vote177 views3 answers
Remove folders from remote git
SQL
0 vote172 views1 answer
Insert set mysql
SQL
3 votes172 views3 answers
Update join
SQL
7 votes146 views1 answer
Mysql load data infile csv
SQL
0 vote174 views1 answer
Db format in quotation
SQL
32 votes212 views6 answers
Rename column mysql
SQL
0 vote177 views1 answer
Get date from timestamp in mysql
SQL
0 vote180 views1 answer
Raiserror with nowait
SQL
11 votes193 views5 answers
Laravel db facade
SQL
0 vote170 views1 answer
Alasql delete column
SQL

Share