/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

16 votes195 views3 answers
Update table from another table
SQL
2 votes172 views1 answer
Can you use a where clause for a child query
SQL
0 vote189 views1 answer
Java nosql sort
SQL
0 vote187 views4 answers
How to drop all tables in sql
SQL
3 votes177 views2 answers
To_char oracle
SQL
1 vote272 views3 answers
Showing all columns in an sqlite table
SQL
0 vote207 views1 answer
Sql count total by foreign key
SQL
0 vote289 views1 answer
Mysql grant access to one database
SQL
0 vote238 views1 answer
Oracle running queries
SQL
1 vote200 views1 answer
Sql set auto increment back to 0
SQL

Share