> >Name date >John 01/01/2005 >Peter 08/01/2005 >John 15/01/2005 >James 22/01/2005 >Peter 31/01/2005 >Bill 02/05/2005 > > >I want select result is : > >Name date >John 15/01/2005 >James 22/01/2005 >Peter 31/01/2005 >Bill 02/05/2005 > >>
select * from myTable t1 ; where myDate = (select max(myDate) from myTable t2 where t1.Name == t2.Name)Cetin