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

10 votes188 views2 answers
Show tables in schema oracle
SQL
0 vote215 views1 answer
Delete from table where length sql
SQL
1 vote185 views1 answer
Mysql decimal allow negative values?
SQL
0 vote174 views1 answer
SQL loop with cursor
SQL
0 vote136 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote215 views1 answer
Mysql date without time
SQL
9 votes184 views3 answers
Oracle undo usage by session
SQL
5 votes171 views2 answers
Ranking functions in sql
SQL
1 vote173 views2 answers
Pl sql case
SQL
0 vote178 views1 answer
Mysql change timestamp on update
SQL