MySQL: LIMIT by a percentage of the amount of records?

by

Best answer I found:

SELECT*
FROM    (
    SELECT list.*, @counter := @counter +1 AS counter
    FROM (select @counter:=0) AS initvar, list
    ORDER BY value DESC   
) AS X
where counter <= (10/100 * @counter);
ORDER BY value DESC

Change the 10 to get a different percentage.

More Related Contents:

  1. If two columns are 1 then make new column
  2. MySQL – Get row number on select
  3. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  4. How can I tell when a MySQL table was last updated?
  5. Retrieving the last record in each group – MySQL
  6. Cast from VARCHAR to INT – MySQL
  7. Operand Should Contain 1 Column – MySQL NOT IN
  8. Connect By Prior Equivalent for MySQL
  9. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  10. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  11. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  12. Determine Rank based on Multiple Columns in MySQL
  13. Best practices for SQL varchar column length [closed]
  14. ALTER TABLE to add a composite primary key
  15. How to select the most recent set of dated records from a mysql table
  16. How to get current date & time in MySQL?
  17. Set value to NULL in MySQL
  18. Laravel join with 3 Tables
  19. SELECT query return 1 row from each group
  20. MySql Single Table, Select last 7 days and include empty rows
  21. mysql SQL: specific item to be first and then to sort the rest of the items
  22. How to regex in a MySQL query
  23. When is a timestamp (auto) updated?
  24. MySQL Group By Hours
  25. RMySQL dbWriteTable with field.types
  26. Syntax error on MERGE statement
  27. INSERT INTO Table from multiple tables
  28. Execute INSERT if table is empty?
  29. Mysql How do you create a clustered index?
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment