i have table that contain appointmentdate and FirstName and LastName i need sql Query for sorting
i have records like
AppointmentDate FirstName LastName
10/1/2009 2.00 Munish Rathore
10/1/2009 3.20 Munish Rathore
10/1/2009 3.50 Munish Rathore
10/1/2009 4.50 Munish Rathore
10/1/2009 3.50 Sandeep Shanrma
10/1/2009 4.50 Sandeep Shanrma
10/1/2009 3.50 Vicky Shanrma
10/1/2009 4.50 Vicky Shanrma
Now i want to show in Grid in particular
sorting order
10/1/2009 3.50 Munish Rathore
10/1/2009 4.50 Sandeep Shanrma
10/1/2009 4.50 Vicky Shanrma
after then all repeat records
10/1/2009 2.00 Munish Rathore
10/1/2009 3.20 Munish Rathore
10/1/2009 3.50 Munish Rathore
10/1/2009 3.50 Sandeep Shanrma
10/1/2009 3.50 Vicky Shanrma
10/1/2009 3.50 Munish Rathore
10/1/2009 4.50 Sandeep Shanrma
10/1/2009 4.50 Vicky Shanrma
10/1/2009 2.00 Munish Rathore
10/1/2009 3.20 Munish Rathore
10/1/2009 3.50 Munish Rathore
10/1/2009 3.50 Sandeep Shanrma
10/1/2009 3.50 Vicky Shanrma
Means all single unique first and last name will merge
Thanks
