Top 1 for each group

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

You would use the MAX() aggregate function.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

TB-462197 SSC Eights! Points: 990 More actions · Answer 2

yep. That would do it. I'm going to hide under my desk now. Thanks!!!

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Is this what you are after?

/*

code date ...

24 5/15/08

24 6/12/07

26 1/15/02

27 7/24/08

27 5/01/05

*/

create table #TestTab (

code int,

codedate datetime

);

insert into #TestTab

select 24, '2008-05-15' union all

select 24, '2007-06-12' union all

select 26, '2002-01-15' union all

select 27, '2008-07-24' union all

select 27, '2005-05-01';

select

code,

max(codedate)

from

#TestTab

group by

code;

drop table #TestTab;

RBarryYoung SSC Guru Points: 143329 More actions · Answer 4

Glad I could help.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]