How to find a gap in the table between min and max value using pure SQL

Revisions (5)

Comments & Discussions

Revisions

Compare	Revision	Minor	Date	Status	Editor
	publicly available	No	14 Nov '12 - 7:25	Available	Jörgen Andersson
Updates in content. 8 changes had been made.
	3	No	14 Nov '12 - 7:12	Available	Jörgen Andersson
Updates in content. 93 changes had been made.
	2	No	14 Nov '12 - 6:04	Available	Jörgen Andersson
Forgot Parenthesis
	1	No	14 Nov '12 - 4:35	Available	Jörgen Andersson

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Jörgen Andersson

Database Developer

Sweden

Member

No Biography provided

Alternative to How to find a gap in the table between min and max value using pure SQL

While Shanalal Kasims solution is cool, it doesn't work when you have a larger gap in the sequence.This is pure SQL and should work for all cases:WITH M AS ( SELECT Max(SEQUENCE) s FROM table1 WHERE id = 1 ),numbers(n) AS ( SELECT 1 AS n UNION ALL...

Type	Answer
Licence	CPOL
First Posted	13 Nov 2012
Views	0
Bookmarked	0 times

SQL

The Next Version of Android - Some of What's Coming

Get the Insider News free each morning.

Layout: fixed | fluid

		9,884,459 members (46,370 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using