>Hi
>
>I want make one select . i have this table :
>
>

>
>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
>
>

>
>that means that i only want the date for each person more next today .
>
>Thanks

select * from myTable t1 ;
 where myDate = (select max(myDate) from myTable t2 where t1.Name == t2.Name)

Cetin