/SQL/How to display top 50 rows?

How to display top 50 rows?

Rownum in sql

SELECT ROWNUM, a.*
FROM (SELECT customers.*
      FROM customers
      WHERE customer_id > 4500
      ORDER BY last_name) a;

0

Source: techonthenet.com

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

7 votes330 views1 answer
Alter sequence set current value oracle
SQL
0 vote318 views1 answer
Query on date sqlite flutter
SQL
23 votes324 views4 answers
Sql server substring
SQL
0 vote307 views1 answer
How to check which sp is running in sql server
SQL
2 votes311 views2 answers
Laravel query builder toSql
SQL
3 votes336 views2 answers
Install mysql powershell
SQL
0 vote316 views1 answer
Mysqldump don't drop table
SQL
0 vote373 views1 answer
Sql trim whitespace
SQL
0 vote354 views1 answer
Amount of entries in a table psql
SQL
2 votes280 views1 answer
Oracle current date without time
SQL

Share