SQL query please help - Tutorialized

MsSQL

User Name:

Password:

Remember me


		Tutorialized Forums > Databases > MsSQL
SQL query please help Discuss SQL query please help in the MsSQL forum on Tutorialized. SQL query please help Microsoft SQL Server forum covering the relational database management system (RDBMS). SQL Server is scalable, encompassing users from small to medium companies all the way up to large enterprise firms. Discuss it here in detail.

Add This Thread To:

Del.icio.us

Digg

Google

Spurl

Blink

Furl

Simpy

Y! MyWeb

« Previous Thread | Next Thread »

Thread Tools

Search this Thread

Rate Thread

Display Modes

Tutorialized Forums Sponsor:

October 28th, 2012, 12:15 PM

Ocean79

Registered User

Join Date: Oct 2012

Posts: 1

Time spent in forums: 24 m 27 sec
Reputation Power: 0

SQL query please help

Hi,

I would really appreciate help with this

I have a table that is made of numbers . Let's say first is 1 and last is 9.

Every time a number is sent it jumps by doubles of 1

1,2,4,5,7,9

I need to create a simple select to find the numbers that are missing (3,6,8)

I would really appreciate the help

Thanks

Viewing: Tutorialized Forums > Databases > MsSQL > SQL query please help

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump