Home » SQL & PL/SQL » SQL & PL/SQL » Ok, I give up...
Ok, I give up... [message #2730] Thu, 08 August 2002 09:08 Go to next message
Rich Petersen
Messages: 22
Registered: February 2002
Junior Member
Ok,

Say I have a table with two columns:

LetterValue NumberValue
A 1
A 2
A 3
B 4
B 5
C 6
C 7
C 8
C 9

How can I construct a query that would return the distinct Letters with it's LOWEST value:

A 1
B 4
C 6

I am either having a brain lock, or this is harder than I think it is using only a Select statement.

Thanks!!!

Rich
Re: Ok, I give up... [message #2732 is a reply to message #2730] Thu, 08 August 2002 09:28 Go to previous message
Rich Petersen
Messages: 22
Registered: February 2002
Junior Member
Forget...I got it..
Previous Topic: Query about Date Field conversion
Next Topic: PL/SQL procedure ending after retreiving n number of rows and not going through the complete table
Goto Forum:
  


Current Time: Thu Mar 28 15:54:37 CDT 2024