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

59 votes435 views6 answers
Alter table sql
SQL
1 vote263 views1 answer
Mysql best tutorial for beginners
SQL
21 votes267 views4 answers
Add column mssql
SQL
0 vote272 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
1 vote258 views1 answer
Postgres count string length
SQL
2 votes328 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote259 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
20 votes262 views4 answers
Sqlite create table if not exists
SQL
0 vote237 views1 answer
Postgres create database if not exists
SQL
24 votes294 views4 answers
Postgres delete database
SQL