MySQL top percent

SELECT price FROM prices p1 WHERE
(SELECT count(*) FROM prices p2 WHERE p2.price >= p1.price) <=
     (SELECT 0.1 * count(*) FROM prices)
);

Source: stackoverflow.com

MySQL top percent

SELECT * FROM prices WHERE price >= (SELECT price FROM prices p1 WHERE
(SELECT count(*) FROM prices p2 WHERE p2.price >= p1.price) <=
     (SELECT 0.1 * count(*) FROM prices)
);

Source: stackoverflow.com

Similar codes

0 vote215 views1 answer
Ansi sql count duplicate rows
SQL
8 votes179 views3 answers
Duplicate entry
SQL
8 votes197 views1 answer
Declare table variable sql server
SQL
0 vote195 views3 answers
Convert sql query to python pandas
SQL
0 vote192 views1 answer
Sql server split string and insert into table select
SQL
2 votes186 views3 answers
Application.properties spring boot mysql
SQL
0 vote193 views1 answer
Show size of all tables postgres
SQL
0 vote203 views1 answer
Copy Table from SQL to CSV
SQL
31 votes186 views3 answers
Sql count(*)
SQL
1 vote161 views1 answer
Enable mysql slow query log
SQL