I have three column in a Table as follows Name, Date, Time. Need a SQL to take the latest date & time for the unique name.
Name Date Time
Jith 1-Dec-15 12:46 PM
Jith 2-Dec-15 3:46 PM
Jith 3-Dec-15 2:20 AM
Jith 3-Dec-15 1:46 AM
Final output should be Jith 3-Dec-15 2:20 AM.
When i was using MAX function of Date & Time separately output was Jith 3-Dec-15 12:46PM.
Please help in creating SQL, to sort DATE&TIME together and take the MAX date&time.
Thank you in advance.