Sql Statement to get most recent records based on date time : I need help with query to fetch most recent record based on DateTime field in data base.its format is YYYY-MM-DD HH:MINS:SEC:Milliseconds

when ever new records get created in database only those records must be fetched and display on third party application.

Below queries fetch all records on application, can we put it in subquery and pull only recent records or any other best way

SELECT     User.ID, User_State.Name, User_State.Code, User_State.TestState, Details.FirstName, Details.LastName, 
                      Details.LoginName, User_State.DateTime,call.QueueCalls, call.CallsAband 
FROM         User INNER JOIN
                      User_State ON User.ID = User_State.ID INNER JOIN
                      Details ON User.ID = Details.ID INNER JOIN
                      Call ON User_State.Key = Call.Key  Where User_State.DateTime >= CONVERT(DateTIme, DATEDIFF(DAY,0,GETDATE())) order by DateTime DESC


Thanks

