View previous topic :: View next topic
|
Author |
Message |
Deeps1234
New User
Joined: 26 Jun 2009 Posts: 2 Location: US
|
|
|
|
Hi,
One of my queries output is
Code: |
Id lower lmt upper lmt
S1 0 100
S1 0 200
S1 0 300
S1 100 200
S1 100 300
S1 200 300
|
I have pick the row containing lowest of upper lmt for a combination of Id and lower lmt.
Code: |
Output should be:
S1 0 100
S1 100 200
S1 200 300
|
How to do this?
Help will be much appreciated.
Regards,
Deep |
|
Back to top |
|
|
vinay upadhyay
New User
Joined: 13 May 2007 Posts: 14 Location: chennai
|
|
|
|
Please try this one and let me know
select * from table1 a where
a.upper_lmt =
(select min(upper_lmt) from table1
where lower_lmt = a.lower_lmt and id = a.id) |
|
Back to top |
|
|
sajjan jindal Warnings : 1 New User
Joined: 09 Sep 2007 Posts: 60 Location: india
|
|
|
|
Please check if the following query works.
select ID, lower lmt, MIN(UPPER lmt) as up lmt
from table1
group by ID, lower lmt. |
|
Back to top |
|
|
|