Which clause is used to sort the rows of the final result set by one – McqOptions

MCQOPTIONS

1.	Which clause is used to sort the rows of the final result set by one or more columns ?
A.	ORDER BY
B.	HAVING
C.	FROM
D.	WHERE
E.	None of these
Answer» B. HAVING

Discussion

No Comment Found

Related MCQs

In the following query person_id can beSELECT Emp_id, fname,Lname, Birth_date FROM Employee WHERE Emp_id=101;
What will be the output of the query given below?SELECT emp_id, fname, lnameFROM employeeWHERE title='Manager AND start_date > 2016-03-20;
What will be the output of the query given below?SELECT *FROM ArmyWHERE (title= Sergeant ) OR (start_date=1995-03-20);
What will be the output of the query given below?SELECT *FROM StudentWHERE (title= Monitor ) AND (start_date=2019-01-25);
What will be the output of the query given below?SELECT *FROM StudentWHERE title= Monitor ;
What will be the output of the query given below?SELECT *FROM employeeWHERE (title= HEAD TELLER ) OR (start_date > 2013-01-24);
What will be the output of the query given below?SELECT *FROM ArmyWHERE (title= Sergeant ) AND (start_date > 1995-03-20);
What will be the output of the query given below?SELECT Student_id, FirstName, LastNameFROM StudentWHERE title= Monitor AND start_date=2017-02-25;
What will be the output of the query given below?SELECT Id, FirstName, LastNameFROM StudentWHERE title= Monitor ;
Which clause is used to filter out unwanted Groups ?