SELECT * FROM Mytable ORDER BY userID, Date I assume Date is really a date/time type and not varchar...