Getting distinct records in SQL 2000

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mark Cowne One Orange Chip Points: 26986 More actions · Answer 1

Which ID do you want?

select name,max(id) as id

from test

group by name

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

Bimal-332935 Newbie Points: 2 More actions · Answer 2

Newbie

Points: 2

April 1, 2009 at 3:58 am

Thanks Mark for that.