This page contains Solution of Both Type A and Type B Questions of Class 12 IP Chapter 7 Querying Using SQL Sumita Arora Textbook Solution.
2. What is the default sort order of ORDER By Clause?
Ans: The ORDER BY clause sorts in Ascending order by default.
3. Write an example query those sorts on three columns.
SELECT Empname, Deptname, Designation, Salary
ORDER BY Empname, Deptname DESC, Salary;
4. Write a query that sorts the data of table student on the basis of Project-Group (in ascending order), section (in descending order), Marks (in descending order)
SELECT * FROM Student ORDER BY Project_Group, Section DESC, Mark DESC;
8. What type of function can you use with GROUP BY and HAVING clauses?
Ans: We can use Aggregate functions also known as multiple row function with GROUP BY and HAVING clause.