SQL Question
From: Josef Huber <josef.huber_at_ennstal.at>
Date: 1998/01/28
Message-ID: <34cf1702.0_at_news.profinet.at>#1/1
Date: 1998/01/28
Message-ID: <34cf1702.0_at_news.profinet.at>#1/1
please help
I have a table test with one column val.
Test
3
4
5
9
10
13
I need a query with the below output
Output:
6
7
8
11
12
I need also a query where i can find the lowest val + 1 from the table Is this query a good way to do this ?
SELECT val + 1 FROM test t
WHERE val=t.val+1)
PS: sorry for my english
Ciao,
E-Mail: josef.huber_at_ennstal.at
WHERE val NOT IN
(SELECT val FROM test
Joe
Home: http://www.liezen-online.at