/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

1 vote271 views1 answer
T-SQL / AZURE Reseed
SQL
38 votes294 views6 answers
Alter table mysql
SQL
3 votes260 views2 answers
Oracle apex view logs
SQL
1 vote255 views1 answer
Media sql
SQL
0 vote280 views1 answer
Updating database in sql
SQL
0 vote244 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote264 views1 answer
Day of the week sqlite
SQL
0 vote255 views1 answer
Jdbc sql connection string
SQL
1 vote249 views2 answers
Update with inner join sql server
SQL
0 vote258 views1 answer
What is SQL data store?
SQL

Share