
March 29th, 2012, 11:17 AM
|
|
Registered User
|
|
Join Date: Feb 2012
Posts: 7
Time spent in forums: 3 h 25 m 29 sec
Reputation Power: 0
|
|
|
Max id if multiple records exist help please!!
Hi,
i am having a hard time figuring out how to go about this.
so basically IF multiple records with the same start date exist, i have to select the one with the max(note_id)
Example
note_id/start_date
88888/08-01-2001
98788/08-01-2001 <===
55555/08-01-2001
54856/08-01-2001
in the example above, i would need to pick the one with the arrow
note_id-98788 and start_date-08-01-2001
|