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

1 vote164 views1 answer
Temp table vs variable table in sql server
SQL
1 vote129 views1 answer
Ms sql how to see active job current run time
SQL
-1 vote176 views2 answers
Postgresql get last 10 records
SQL
1 vote162 views1 answer
Pv mysql import
SQL
1 vote193 views1 answer
Mysql select all and rename one
SQL
32 votes180 views6 answers
How to change column name in sql
SQL
0 vote161 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
31 votes172 views3 answers
SQL Server change column data type
SQL
0 vote161 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote160 views1 answer
Sql join on a subquery
SQL