SELECT query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a table:
column: A | B
----------------
row: a | 1
a | 2
c | 2
c | 3

I need to get from this table all "distinct" records with maximum value in B
for particular value in A
So in this case I need the result will have 2 rows: a|2, C|3
I tried to make some subqueries, but always I anded up with the only row C|3
what was wrong.

Any idea how to do it?

Thanks,

Lubomir
 
Back
Top