/SQL/Select top 10 rows in sql

Select top 10 rows in sql

Select top 10 rows in sql

SELECT TOP 10 * FROM Customers;

1

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

0 vote338 views1 answer
Restore backup mysql .gz
SQL
11 votes352 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
3 votes334 views1 answer
Sql replace character in string in all records
SQL
0 vote336 views2 answers
Android sqlite query join
SQL
2 votes320 views1 answer
How to add where command in update comand with joins
SQL
2 votes405 views5 answers
Tablespace ORACLE
SQL
1 vote274 views1 answer
Postgres reset auto increment
SQL
4 votes328 views1 answer
Id primary key auto generated
SQL
5 votes301 views2 answers
Mysql where in array
SQL
4 votes340 views1 answer
Alter session set nls_date_format
SQL

Share