Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’ ORDERBY Age; The statement has a syntax error?

(A) The statement displays the entire fields from emp in which the Empname is ALI in any order
(B) The statement displays the entire fields from emp in which the Empname is ALI in descending order of their age
(C) The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age
(D) None of the above

»Important Links:

Latest Jobs in PakistanGovt Jobs in PakistanPrivate Jobs in Pakistan
NTS JobsPPSC JobsFPSC Jobs
Teaching JobsNADRA JobsBank Jobs
English McqsGeneral Knowledge McqsPak Studies Mcqs
Current Affairs McqsCurrent Affairs Mcqs PDFCurrent Affairs of Pakistan
Books PDFNotes PDFIslamic Studies Mcqs

Leave a Reply

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

error: Content is protected !!