/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 vote144 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote138 views1 answer
Sql select non unique
SQL
0 vote157 views1 answer
Mysql utc timestamp
SQL
0 vote134 views1 answer
Equi joins in oracle
SQL
0 vote140 views1 answer
Alter table myisam to innodb
SQL
9 votes133 views3 answers
Show table columns mysql command line
SQL
-2 votes146 views1 answer
Create trigger syntax
SQL
0 vote136 views1 answer
How to count null values in sql
SQL
1 vote157 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote130 views1 answer
Postgresql get current user name
SQL

Share