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 vote218 views2 answers
How covert into int in maria db
SQL
5 votes197 views3 answers
Sql make column nullable
SQL
0 vote260 views1 answer
Osm2pgsql mac
SQL
0 vote199 views1 answer
Sql find leading space
SQL
0 vote226 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote250 views1 answer
Drop table BigQuery table columns
SQL
7 votes248 views1 answer
Show line number in sql server
SQL
3 votes303 views1 answer
How to get yesterday date in sql
SQL
2 votes215 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote214 views1 answer
Join creating duplicate columns sqllite
SQL