Click here to Skip to main content
11,704,044 members (67,461 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as

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

, 16 Nov 2012 CPOL 0
select sequence from SequenceTable where sequence NOT IN (select sequence FROM Table1 WHERE id=8)I've created another table named SequenceTable and stored value from 1 to 10 and then applying the above query.

Revisions


  

Compare Revision Minor Date Status Editor
2 - publicly available No 17-Nov-12 0:35 Available sahabiswarup
Updates in content. 1 changes had been made.
1 No 15-Nov-12 4:23 Available sahabiswarup

License

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

Share

About the Author

sahabiswarup
Software Developer Rumtek Technologies
India India
You may check about me at www.dotnetcode.net
contact email biswarup@rumtekinfo.com

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.150819.1 | Last Updated 17 Nov 2012
Article Copyright 2012 by sahabiswarup
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid