How do I order two columns in SQL?

Question

My output to the question was this:-

FIRSTNAME  COURSENAME
---------- --------------------
Anand      C++
Bala       C++
Dileep     Linux and C
Gowri      Java
Gowri      Linux and C
Gowri      C#
John       C++
John       Oracle
Prem       Linux and C
Priya      Java
Priya      Oracle
Priya      C#
Rahul      Oracle

But the expected output is:-

FIRSTNAME  COURSENAME
---------- --------------------
Anand      C++
Bala       C++
Dileep     Linux and C
Gowri      C#
Gowri      Java
Gowri      Linux and C
John       C++
John       Oracle
Prem       Linux and C
Priya      C#
Priya      Java
Priya      Oracle
Rahul      Oracle

My code:

select firstname, coursename
from course
inner join
    (select student.firstname as firstname, registration.courseid
     from student
     inner join registration on student.studid = registration.studid
     group by student.firstname, registration.courseid) q1 on q1.courseid = course.courseid
order by firstname asc;

How do I arrange two columns in ascending order keeping the other fixed? (maybe I didn't sound good in explaining this)

Do you want to order by the column firstname then coursename? — Hayden Passmore, Aug 14 '17 at 03:54
Possible duplicate of [SQL multiple column ordering](https://stackoverflow.com/questions/2051162/sql-multiple-column-ordering) — Hayden Passmore, Aug 14 '17 at 03:55

score 6 · Answer 1 · answered Aug 14 '17 at 03:54

6

order by firstname, coursename

Or

order by firstname asc, coursename asc

answered Aug 14 '17 at 03:54

Arun Vinoth-Precog Tech - MVP

22,364
14
59
168

This is the expected resultset. How you conclude the Gowri & Priya coursename ordering ? – Arun Vinoth-Precog Tech - MVP Aug 14 '17 at 04:13
1

Arun answer is correct because Alphabetically J comes before L – Khalil Aug 14 '17 at 04:17

How do I order two columns in SQL?

1 Answers1