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

11 votes100 views1 answer
Mysql order by two columns priority
SQL
2 votes110 views1 answer
Q operator in sql
SQL
0 vote94 views1 answer
Create new table pl sql
SQL
15 votes132 views4 answers
Sql update from select
SQL
2 votes99 views1 answer
How to search table name in stored procedure in sql server
SQL
1 vote105 views1 answer
Drop column if exists sql server
SQL
12 votes92 views4 answers
SQL Where
SQL
-1 vote110 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote88 views1 answer
Alter boolean column postgresql
SQL
3 votes115 views2 answers
Sqlite show table structure
SQL