Select distinct question 1

[williamkremer]

Hi all -- I can't remember how to do this: I want to select distinct company, field2, datefield, field4 where field4 = 'Val'. Now, I only want one listing for the company, and that is the record with the most recent datefield. Make sense? Thanks a bunch

"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill

 

[SQLDenis]

Thanks, glad I could help

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/