how to show the latest data

Question

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

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

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

From the example you've given, it would look like using MAX would suit you needs.

However from the description you seem to need more and need to filter on rownumber()

heres an example

with cteGradYears(Person,Collage,YearGrad,RowN)(

Select Person,Collage,YearGrad,row_number() over partition by(Person order by year desc)

from GradTable

)

Select Person,Collage,YearGrad

from cteGradYears

where RowN = 1

Clear Sky SQL
My Blog[/url]

talhakosen Grasshopper Points: 19 More actions · Answer 2

Grasshopper

Points: 19

July 20, 2009 at 3:18 am

Thank you ! it gave an good idea ..

Grant Fritchey SSC Guru Points: 399289 More actions · Answer 3

MAX works well in that situation, but depending on your indexes, TOP 1 with an ORDER BY can work consistently better. You might try that too.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

talhakosen Grasshopper Points: 19 More actions · Answer 4

Grasshopper

Points: 19

July 21, 2009 at 2:58 am

thanks for your interest )