Click here to Skip to main content
12,698,024 members (23,538 online)
Click here to Skip to main content

Tagged as

Stats

0 views
Posted

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

, 16 Nov 2012 CPOL
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 16-Nov-12 14:35 Available sahabiswarup
Updates in content. 1 changes had been made.
1 No 14-Nov-12 18: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...

Pro
Pro
| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170118.1 | Last Updated 17 Nov 2012
Article Copyright 2012 by sahabiswarup
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid