Selecting Top Record 1

[mtepfer]

can have numerous inspection dates per client, want to select the top record from each client and display.

For instance may have :

ClientNo Name Type Date
1 Smith annual 2/1/08
1 Smith annual 2/1/07
1 Smith Initial 2/1/06
2 Doe Annual 12/7/07
2 Doe Initial 12/1/06

Only want to Display :

ClientNo Name Type Date
1 Smith annual 2/1/08
2 Doe Annual 12/7/07

Basically the first record based on the change of client number. How is this possible in SQL?

 

[AlexCuse]

Take a look at this:

http://www.alexcuse.com/BlogEntry.aspx?PostID=26

And in the future, this type of question is better suited for forum183

Hope this helps,

Alex

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page

 

[mtepfer]

Thanks Alex, exactly what i needed. Sorry about the wrong forum, thought i had clicked programming, need to proof better before posting.