Try
SELECT * FROM mytable mt1
WHERE Saved = (SELECT MAX(saved) FROM mytable mt2 WHERE mt2.id = mt1.id)
SELECT * FROM mytable mt1
WHERE NOT EXISTS (SELECT 1 FROM mytable mt2 WHERE mt2.id = mt1.id
AND mt2.Saved > mt1.Saved)>Consider the table
>
>Id Bal Saved
>1 100 2/5/2008
>1 90 2/6/2008
>1 80 2/7/2008
>2 250 2/6/2008
>2 150 2/9/2008
>
>
>I am tring to create a query that will give me the following result set:
>
>Id Bal Saved
>1 80 2/7/2008
>2 150 2/9/2008
>
>i.e., one record per Id that has the newest date.
>
>Thanks,
>Einar
--sb--
