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 vote164 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote152 views1 answer
Horizontal join sqlite
SQL
0 vote165 views1 answer
Str_to_date sql server
SQL
0 vote142 views1 answer
Restart sql server command line linux
SQL
0 vote142 views1 answer
Get number of rows in every table mysql
SQL
0 vote161 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote186 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote162 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote156 views1 answer
Proc sql not in working
SQL
5 votes152 views2 answers
Mysql drop table cascade
SQL