Question

Write a query to display list of students name who all are from IT department. Sort the result based on students name in descending.

Hint:Use Subquery

Answer 1

#Select student name from (table name) where department='IT';

#Select * from (table name) order by desc;

Answer 2

Concept:

Query language (QL) is a computer programming language that uses queries to seek and get data from databases and information systems. It uses organized and formal programming command-based queries given by the user to search and extract data from host databases.

Find:

Sort the student's name in descending order of IT department.

Solution:

The column of student name be 'name'.

The table name be 'student'.

SELECT name FROM student WHERE department='IT'

This selects students from IT department.

SELECT * FROM student ORDER BY desc.

This sorts the name of the students in descending order.

#SPJ3