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

4 votes228 views2 answers
Postgresql float data type
SQL
0 vote212 views1 answer
Top 3 salary in sql
SQL
0 vote193 views1 answer
Set default value now() date
SQL
7 votes210 views1 answer
Sql limit decimal places
SQL
0 vote209 views3 answers
Remove folders from remote git
SQL
0 vote201 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote241 views1 answer
Postgresql remove new line from string
SQL
11 votes330 views2 answers
Import mysql dump command line windows
SQL
0 vote193 views1 answer
How change the field place in mysql
SQL
10 votes205 views3 answers
How to fetch first 5 characters in sql
SQL