SQL: Repeat a result row multiple times, and number the rows

by

You could use a numbers table 

SELECT value, count, number
FROM table
    JOIN Numbers 
        ON table.count >= Numbers.number

Here is a SQLFiddle using MSSQL

More Related Contents:

  1. How to select the nth row in a SQL database table?
  2. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  3. Why do results from a SQL query not come back in the order I expect?
  4. Best practices for SQL varchar column length [closed]
  5. Relationship between catalog, schema, user, and database instance
  6. What resources exist for Database performance-tuning? [closed]
  7. how to cast the hexadecimal to varchar(datetime)?
  8. What are the max number of allowable parameters per database provider type?
  9. Why in SQL NULL can’t match with NULL?
  10. In SQL Server how to get the count of child if both parent and child are available [closed]
  11. SQL Print the name of all Employees together with the name of their supervisor
  12. How to filter SQL results in a has-many-through relation
  13. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  14. Storing JSON in database vs. having a new column for each key
  15. Simple Random Samples from a Sql database
  16. Stored Procedure with optional “WHERE” parameters
  17. When to use SELECT … FOR UPDATE?
  18. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  19. Does mysql have the equivalent of Oracle’s “analytic functions”?
  20. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  21. Are SELECT type queries the only type that can be nested?
  22. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  23. Postgres LEFT JOIN with WHERE condition
  24. What does SQL Select symbol || mean?
  25. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  26. How do I list all the columns in a table?
  27. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  28. What happens when I exhaust a bigint generated key? How to handle it?
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment