/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 vote245 views3 answers
Mysql keyword search
SQL
0 vote221 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote265 views1 answer
Selecting specific day in colum sql
SQL
8 votes182 views5 answers
Grant permission in postgres
SQL
0 vote202 views1 answer
Mysql url data type
SQL
0 vote337 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
32 votes194 views6 answers
Insert into values select
SQL
0 vote216 views1 answer
Excel vba import data to sql server
SQL
0 vote238 views1 answer
Rabbitmq service not starting
SQL
5 votes171 views2 answers
Create table
SQL

Share