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 vote194 views1 answer
How to get alternate records from a table in sql
SQL
0 vote149 views1 answer
Mysql read row
SQL
2 votes155 views1 answer
Sql ignore accents
SQL
4 votes150 views4 answers
Date less than in sql
SQL
-1 vote181 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote183 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
2 votes150 views3 answers
How to pass password mysql command line
SQL
0 vote180 views1 answer
Running percentage of total postgres
SQL
5 votes135 views2 answers
Oracle list columns schema
SQL
1 vote152 views1 answer
Mysql show table character set
SQL