| List: | General Discussion | « Previous MessageNext Message » | |
| From: | SpamSucks86 | Date: | December 22 2002 4:37am |
| Subject: | Return every Nth row in a result set | ||
| View as plain text | |||
What would be the SQL query to return every Nth row in a result set? So it would return the 5th row, the 10th row, the 15th row, etc. Thanks for any and all replies!
| Thread | ||
|---|---|---|
| • Return every Nth row in a result set | SpamSucks86 | 22 Dec |
| • RE: Return every Nth row in a result set | JamesD | 22 Dec |
| • 4.1 questions: subqueries which use dual | ric | 22 Dec |
| • re: 4.1 questions: subqueries which use dual | Victoria Reznichenko | 24 Dec |
| • Re: Return every Nth row in a result set | ric | 22 Dec |
| • RE: Return every Nth row in a result set | SpamSucks86 | 22 Dec |
| • Re: Return every Nth row in a result set | Benjamin Pflugmann | 22 Dec |
| • RE: Return every Nth row in a result set | SpamSucks86 | 22 Dec |
| • Re: Return every Nth row in a result set | Richard Clarke | 22 Dec |
| • Re: Return every Nth row in a result set | ric | 22 Dec |
| • Re: 4.1 questions: subqueries which use dual | Richard Clarke | 24 Dec |
| • Re: 4.1 questions: subqueries which use dual | Dan Nelson | 24 Dec |
| • Re: 4.1 questions: subqueries which use dual | Richard Clarke | 24 Dec |
| • Re: 4.1 questions: subqueries which use dual | Mark Matthews | 24 Dec |