/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 vote329 views1 answer
Mysql delete from where like
SQL
0 vote368 views1 answer
Migration graphql
SQL
2 votes334 views1 answer
Sql select min value from multiple columns
SQL
0 vote343 views1 answer
How to set all the min and sec data to zero in sql server
SQL
11 votes787 views4 answers
Reset identity column values in sql server
SQL
15 votes462 views5 answers
Select all tables sql
SQL
2 votes381 views1 answer
Mysql id of inserted row
SQL
0 vote365 views2 answers
Import .sql into postgres db command
SQL
0 vote292 views1 answer
Update sql join multiple tables
SQL
0 vote365 views1 answer
Group by 15 minute interval sql server
SQL

Share