View previous topic :: View next topic
|
Author |
Message |
vijayakumar.yellala
New User
Joined: 19 Apr 2006 Posts: 63 Location: Chennai
|
|
|
|
Hi,
I need a query from below table.
V.NO. SEQ.NO. OWNER S.TYPE S.DATE
V1 1 OW1 S 10/10/2010
V1 2 OW2 R 08/10/2010
V1 3 OW3 1 06/10/2010
V1 4 OW4 R 01/10/2010
Fron above table results would be
Owner name S.date
OW2 08/10/2010
P.Key (V.NO & SEQ.NO)
Plz help me out on this.
Regards
Vijay |
|
Back to top |
|
|
kacks7
New User
Joined: 22 Sep 2010 Posts: 33 Location: chennai(india)
|
|
|
|
hi,
why don't you use select required lcolumns from the table where the v.vno=v2 and seq.no=2. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
you don't need an sql query, you need sql lessons.
This is the first sql statement you'll ever learn in any class. |
|
Back to top |
|
|
acevedo
Active User
Joined: 11 May 2005 Posts: 344 Location: Spain
|
|
|
|
67 posts...mmmmm I guess you should have learnt how to use the Code tag. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
Plz help me out on this. |
Maybe if you publish the "rules" for your query . . . Why was only that one row selected/needed?
Why should people who want to help have to determine what rule(s) you want applied?
After more than 4 years here, you should know this as well as how to use the Code tag. . .
Rather disappointing
d |
|
Back to top |
|
|
|