More on SQL || Type A || Sumita Arora || Class 12 || Computer science || Information practices || Solution
Q1= What is the use of ORDER BY clause?
Q2= What is the default sort order of ORDER BY clause?
Q3= Which function do you use in ORDER BY clauses to specify custom sort order?
Q4= Which clause is used to sort the records of a table?
Q5= Write an example query that sorts on three columns.
Q6= 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).
Q7= What is the difference between HAVING and WHERE clause?
Q8= What is the use of GROUP BY clause?
Q9= What are aggregate functions? What is their use? Give some examples.
Q10= What type of functions can you use with GROUP BY and HAVING clauses?
Q2= What is the default sort order of ORDER BY clause?
Q3= Which function do you use in ORDER BY clauses to specify custom sort order?
Q4= Which clause is used to sort the records of a table?
Q5= Write an example query that sorts on three columns.
Q6= 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).
Q7= What is the difference between HAVING and WHERE clause?
Q8= What is the use of GROUP BY clause?
Q9= What are aggregate functions? What is their use? Give some examples.
Q10= What type of functions can you use with GROUP BY and HAVING clauses?
Post a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )