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 vote201 views1 answer
How to get table id sequence postgres
SQL
16 votes178 views4 answers
Mysql import from sql file
SQL
7 votes188 views1 answer
Query delete duplicates
SQL
0 vote172 views1 answer
Postgres drop type
SQL
0 vote196 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote188 views2 answers
Update query with between in mysql
SQL
1 vote192 views1 answer
Mysql find tables with column name
SQL
3 votes132 views1 answer
Ubuntu install postgresql 12
SQL
5 votes171 views2 answers
Oracle timestamp to date
SQL
0 vote174 views1 answer
Mariadb mysql root access denied
SQL