/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 vote159 views2 answers
Avg() sql
SQL
0 vote199 views1 answer
Psql show db
SQL
0 vote185 views1 answer
Group by two columns postgres
SQL
2 votes187 views1 answer
Q operator in plsql
SQL
0 vote187 views2 answers
Starting mysql service from mac
SQL
2 votes181 views1 answer
Postgresql add entry to table
SQL
8 votes240 views1 answer
Database backup in mysql server recovery
SQL
1 vote192 views2 answers
Snowflake alter column data type
SQL
0 vote212 views1 answer
Leftjoin in sql
SQL
0 vote185 views1 answer
Mysql count number of occurrences in a column
SQL

Share