Query Question

  • Thread starter Thread starter Ivar
  • Start date Start date
I

Ivar

Hi All.

First Time Asking Here :-)
Looking for the SQL for a query on a simple table
Table has 3 fields, all Integer with a number between 1 and 10000
All fields can have duplicates, however: The combination of numbers in
fields 1 and 2 will always be unique.

I am looking for a query that will return unique values of field 1 with the
highest value of field 2.
So if my table contained this:
1 1 1
1 2 3
1 4 6
2 1 3
3 1 3
3 3 3
3 4 1
2 6 2
2 5 2
2 3 7
The Query would return:
1 4 6
2 6 2
3 4 1

Any ideas on the SQL for this, I'm stuck on this one.
Any help would be appreciated.

Ivar
 
Ivar said:
Hi All.

First Time Asking Here :-)
Looking for the SQL for a query on a simple table
Table has 3 fields, all Integer with a number between 1 and 10000
All fields can have duplicates, however: The combination of numbers in
fields 1 and 2 will always be unique.

I am looking for a query that will return unique values of field 1
with the highest value of field 2.
So if my table contained this:
1 1 1
1 2 3
1 4 6
2 1 3
3 1 3
3 3 3
3 4 1
2 6 2
2 5 2
2 3 7
The Query would return:
1 4 6
2 6 2
3 4 1

Any ideas on the SQL for this, I'm stuck on this one.
Any help would be appreciated.
Click to expand...
It's a simple grouping query:
Select Field1,Max(Field2) As MaxField2
FROM simpletable
GROUP BY Field1
 
It's a simple grouping query:
Select Field1,Max(Field2) As MaxField2
FROM simpletable
GROUP BY Field
Click to expand...

MAX, So simple I missed it :-)
Thanks for that
All sorted

Thanks for quick reply

Ivar
 
Back
Top