SQL – Select 3rd & 4th Year Students

student is a database table containing student details whose create DDL is given below.

CREATE TABLE student(id int, name VARCHAR(100), department VARCHAR(3), year int);

Write the SQL to list students belonging to third and fourth year (values in database are 3 and 4) and sort by the column name.
(The name must be the first column in the resultset. The year must be the second column in the resultset. The department must be the third column in the resultset.)

Code:

SELECT name, year, department FROM student WHERE year = 3 or year = 4 ORDER BY name;

Leave a Reply

Your email address will not be published. Required fields are marked *

More posts. You may also be interested in.