SELECT 50 MAX FIRST PRICES without a "WHERE" clause

Question

how to select the first maximum prices in a table without using the clause "where" ?

`SELECT TOP 50 * FROM tab ORDER BY Prices DESC` - depending on RDBMS `TOP/LIMIT/OFFSET - FETCH` — Lukasz Szozda, Apr 14 '19 at 10:10
thank you but u are using sql server in this case , i want it in mysql — Sara, Apr 14 '19 at 10:11
here is the result in sql oracl too : https://stackoverflow.com/questions/470542/how-do-i-limit-the-number-of-rows-returned-by-an-oracle-query-after-ordering — Sara, Apr 14 '19 at 10:26

score 1 · Answer 1 · edited Apr 14 '19 at 12:16

1

In mysql -

SELECT * FROM table_name
ORDER BY price desc LIMIT 50;

edited Apr 14 '19 at 12:16

Nick

answered Apr 14 '19 at 10:15

Khilesh Chauhan

score 1 · Answer 2 · answered Apr 14 '19 at 10:31

1

this will work in mysql:

SELECT 
    select_list
FROM
    table_name
order by column_name
LIMIT 0 , 50;

answered Apr 14 '19 at 10:31

Nikhil S

score 0 · Answer 3 · answered Apr 14 '19 at 11:25

0

SELECT price
FROM table
ORDER BY price DESC
LIMIT 50;

answered Apr 14 '19 at 11:25

Grega

score 0 · Accepted Answer · answered Apr 14 '19 at 12:00

0

Your question is unclear.

If you want 50 rows, even when there are duplicates, then you can use:

select price
from t
order by price desc
limit 50;

If you want 50 distinct prices, then you can use:

select distinct price
from t
order by price desc
limit 50;

answered Apr 14 '19 at 12:00

Gordon Linoff

4 Answers4