/SQL/SQL SELECT TOP Equivalent in oracal

SQL SELECT TOP Equivalent in oracal

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

Similar codes

1 vote217 views1 answer
Create new table from old table
SQL
0 vote185 views1 answer
Initcap in sql
SQL
2 votes150 views2 answers
Mysql get last character of string
SQL
1 vote190 views1 answer
Restart identity postgresql
SQL
8 votes228 views1 answer
Oracle tablespace datafile max size
SQL
2 votes211 views3 answers
Sql delete duplicate
SQL
14 votes197 views2 answers
Oracle limit rows
SQL
0 vote286 views1 answer
Run docker container with database as rds metabase
SQL
3 votes202 views1 answer
Insert into table from another table mysql
SQL
1 vote221 views1 answer
Convert to hexadecimal sql
SQL

Share