/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

0 vote162 views1 answer
How to update date value in sql
SQL
6 votes159 views1 answer
Allsource oracle
SQL
20 votes140 views5 answers
Sql show tables
SQL
0 vote151 views1 answer
New rails app with mysql
SQL
27 votes147 views5 answers
Add column in table
SQL
0 vote170 views3 answers
Join
SQL
0 vote172 views1 answer
Connect laravel to mysql on mac
SQL
1 vote152 views1 answer
Find a column in all tables postgres
SQL
0 vote135 views2 answers
Sqlalchemy core in clause
SQL
3 votes145 views2 answers
Sql asc
SQL

Share