posted 19 years ago
Assuming I have a table with the following attributes:
Name date arrive
Say, for example, I have the following information � they are ordered by date
Name date arrive
Dan 1-feb-2005
James 5-feb-2005
Gore 6-feb-2005
Now, say Gil comes on 6-feb-2005 so the result will be:
Name date arrive
Dan 1-feb-2005
James 5-feb-2005
Gore 6-feb-2005
Gil 6-feb-2005
What if I want Gil to come before Gore (they are on the same date BUT Gil is before GORE � in the alphabetic order)
Does anyone have idea what the SQL Statement to be?
I have
Select Name, Date_Arrive from myTable order by Date_Arrive