How do you select every n-th row from mysql

by 
SELECT * 
FROM ( 
    SELECT 
        @row := @row +1 AS rownum, [column name] 
    FROM ( 
        SELECT @row :=0) r, [table name] 
    ) ranked 
WHERE rownum % [n] = 1

More Related Contents:

  1. SQL select only rows with max value on a column [duplicate]
  2. How to create a MySQL hierarchical recursive query?
  3. What is the error “Every derived table must have its own alias” in MySQL?
  4. MySQL Error 1215: Cannot add foreign key constraint
  5. Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)
  6. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  7. How to grant remote access permissions to mysql server for user?
  8. mySQL convert varchar to date
  9. Generating a series of dates [duplicate]
  10. How to take backup of a single table in a MySQL database?
  11. Add Foreign Key to existing table
  12. Auto Generate Database Diagram MySQL [closed]
  13. MySQL maximum memory usage
  14. MySQL JOIN the most recent row only?
  15. What does SQL clause “GROUP BY 1” mean?
  16. Bogus foreign key constraint fail
  17. INSERT … ON DUPLICATE KEY UPDATE with WHERE?
  18. Error #2002 Can’t connect to local MySQL server through socket ‘/Applications/MAMP/tmp/mysql/mysql.sock’ (2)
  19. Syntax error when using except in a query
  20. Easiest way to copy a table from one database to another?
  21. Using index, using temporary, using filesort – how to fix this?
  22. sql like operator on integer
  23. How to get the max of two values in MySQL?
  24. How to connect locally hosted MySQL database with the docker container
  25. How to make a primary key start from 1000?
  26. MySQL – SELECT * INTO OUTFILE LOCAL ?
  27. The best way to remove value from SET field?
  28. how to partition a table by datetime column?
  29. Count duplicates records in Mysql table?
  30. Errno 121, duplicate key on write or update?

Leave a Comment