order by date_arrive but what if...

[Peter Primrose]

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

[Loren Rosen]

You can sort by more than one column:

Select Name, Date_Arrive from myTable order by Date_Arrive, Name

[Peter Primrose]

thanks this solves the problem