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

0 vote121 views1 answer
Sql server user permissions and roles
SQL
0 vote187 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
1 vote124 views1 answer
Oracle stop job
SQL
0 vote124 views2 answers
Suse stop MySQL
SQL
0 vote113 views1 answer
Systemverilog unique constraint unique values
SQL
1 vote114 views1 answer
Sql get missing id
SQL
0 vote141 views1 answer
Sql query inline if
SQL
1 vote113 views1 answer
Set autoincrement to 0
SQL
0 vote122 views1 answer
Top frequency in sql server
SQL
0 vote123 views1 answer
Mysqli_connect using prepare statement
SQL