/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 votes333 views2 answers
Execute mysql file
SQL
1 vote343 views1 answer
Psql connect
SQL
4 votes357 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote328 views2 answers
Mysql dump structure only
SQL
2 votes306 views1 answer
Insert from table tsql
SQL
0 vote282 views1 answer
How to get last client id sql
SQL
0 vote316 views1 answer
What is mysql_pconnect
SQL
10 votes286 views1 answer
Oracle view dependencies
SQL
5 votes377 views1 answer
Mysql count lines
SQL
0 vote312 views1 answer
Plpgsql if statement
SQL

Share