Select TOP X (or bottom) percent for numeric values in MySQL

by

just as an FYI (i know this question is a few years old), this can be done other, cleaner ways as well.

SELECT * FROM product_table WHERE price >= (SELECT price FROM product_table 
ORDER BY price DESC LIMIT 1 OFFSET (SELECT 0.1 * COUNT(*) FROM product_table));

i ran a similar query over a very large database, and it ran very quickly.

More Related Contents:

  1. How to delete from select in MySQL?
  2. How do I UPDATE from a SELECT in SQL Server?
  3. MySQL Insert query doesn’t work with WHERE clause
  4. quick selection of a random row from a large table in mysql
  5. Delete from two tables in one query
  6. PostgreSQL GROUP BY different from MySQL?
  7. Fulltext Search with InnoDB
  8. MySQL’s now() +1 day
  9. Rewriting mysql select to reduce time and writing tmp to disk
  10. How do I convert from BLOB to TEXT in MySQL?
  11. Can you access the auto increment value in MySQL within one statement?
  12. Which SQL query is better, MATCH AGAINST or LIKE?
  13. How do I select all the columns from a table, plus additional columns like ROWNUM?
  14. MySQL, Get users rank
  15. Mysql: how to select groups having certain values?
  16. Best way to do nested case statement logic in SQL Server
  17. MySQL error 1241: Operand should contain 1 column(s)
  18. How to fill date gaps in MySQL?
  19. Boolean vs tinyint(1) for boolean values in MySQL
  20. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  21. Function for week of the month in mysql
  22. SQL column reference “id” is ambiguous
  23. MySQL Select Query – Get only first 10 characters of a value
  24. Find rows that have the same value on a column in MySQL
  25. what is the difference between GROUP BY and ORDER BY in sql
  26. MySQL SELECT x FROM a WHERE NOT IN ( SELECT x FROM b ) – Unexpected result
  27. MySql bulk load command line tool
  28. ALTER TABLE without locking the table?
  29. MySQL: Typecasting NULL to 0
  30. MySQL subquery returns more than one row

Leave a Comment