Trouble gleaning distincts, all fields same except one 2

[Soiboy]

I am getting technically distinct records since one of the fields is different, but I don't want all of them, just the one with the largest number in it.

Here is an example of what my current sql statement is returning:

field1, field2, field3
apple, fruit, 50
apple, fruit, 43
apple, fruit, 32
orange, round, 56
orange, round, 43
orange, round, 31

I want to return the first (largest number) of each, so it returns:
apple, fruit, 50
orange, roound, 56


thanks,

Ed

 

[SQLDenis]

select field1,field2,max(field3)
from table
group by field1,field2

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[jbenson001]

Select field1,field2,max(field3)
from <table>
Group by field1,field2

 

[Soiboy]

beautiful thanks

 

[jbenson001]

glad to help Jim