sql code problem Help pls

TALHAKOSEN

Hi all, i know maybe its is really easy but I've been working on it for ages ! ( Name Diploma year A 1991 A 1986 A 1981 B 2001 B 1996 B 1992 C 1990 C C D 2006 D D i have a 3-4 tables and join them, then it returns lots of people have diplomas from different school, but i need to show the last graduated school for everyone. like that A 1991 B 2001 C 1990 D 2006 . . . . . thanks for now ... Talha

thanks for everything i have...

Blue_Boy

select max(diplomayear),[name]
from mytable
group by [name]

Hope this will help you.

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

TALHAKOSEN

thank you, it works !

thanks for everything i have...

Blue_Boy

No problem.

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.