March 29th, 2012, 11:17 AM
Max id if multiple records exist help please!!
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)
in the example above, i would need to pick the one with the arrow
note_id-98788 and start_date-08-01-2001
March 29th, 2012, 11:43 AM