SQL query question 2

[MinnisotaFreezing]

Hello,

I have data with the records

number letter
1 a
1 b
1 c
2 a
2 b
3 a
3 b
3 c
My question is, how can I return the following data set using SQL
1 c
2 b
3 c
That is, the number with its highest corresponding letter?

Does that makes sense? Is this the right forum for this question? Thanks for your help in advance.

CJB

 

[CPUburn]

hi,

I'm not at a computer where I can test sql's but give this one a try:

"SELECT first(numberfield_name), max(letterfield_name) AS output FROM tablename GROUP BY numberfield_name;"

grtz
CPUburn

 

[petersJazz]

Or like this:
SELECT numberfield_name, max(letterfield_name)
FROM tablename
GROUP BY numberfield_name
ORDER BY numberfield_name;

 

[MinnisotaFreezing]

Thank you both very much.