• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 161
  • Last Modified:

Select Top -- Order By SQL Servef

Hello Expert. May I please have some assistance? I would like to do a select and retrieve one row. I would like to have the most recent modified date to be returned. This Table has multiple rows for the same client id. But the client id is my trigger for returning records.

Thanks for you assistance.
1 Solution
Aneesh RetnakaranDatabase AdministratorCommented:
select ClientID, MAX(ModifiedDate) modifiedDate
from urTable

--to get the most recent record
SELECT * FROM urTable WHERE ModifieDate = (SELECT MAX(ModifiedDate) from urTable )
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now