Selecting the most recent

[markj11]

I have:
FieldA FieldB FieldC
A 1 10/10/2000
A 1 10/11/2000
A 1 10/09/2000
B 1 11/11/2000
B 1 11/09/2000

How do I get:
A 1 10/11/2000
B 1 11/11/2000

Thanks

 

[DotNetGnat]

SELECT t1.FieldA, t1.FieldB, t1.FieldC
from mytable t1
WHERE t1.FieldC in
(Select Top 1 FieldC from mytable t2
WHERE t1.FieldA=t2.FieldA and t1.FieldB=t2.FieldB
order by t2.FieldC DESC)

-DNG

 

[SQLDenis]

select fielda,fieldb,max(fieldc)
from table1
group by fielda,fieldb
order by fielda

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/