/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 vote249 views1 answer
Example database query
SQL
0 vote225 views1 answer
Export partttion and import in oracle
SQL
2 votes220 views1 answer
Import large .sql files into lampp
SQL
0 vote250 views1 answer
What is delimiter in mysql
SQL
0 vote227 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote236 views1 answer
Remove transient options sql wordpress
SQL
25 votes221 views3 answers
Mysql command show tables
SQL
10 votes247 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote240 views1 answer
Postegresql update to null
SQL
3 votes217 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL

Share