What is the significance of ORDER BY emp_id DESC in the given query?SELECT id, First_name, Last_nameFROM StudentORDER BY id DESC;

Data of id will be sorted in ascending order

Data of id will be sorted in either ascending or descending order

Data of id will be sorted in descending order

What is the significance of ORDER BY emp_id DESC in the given query?

1.	What is the significance of ORDER BY emp_id DESC in the given query? SELECT id, First_name, Last_name FROM Student ORDER BY id DESC;
A.	Data of id will be sorted in ascending order
B.	Data of id will be sorted in either ascending or descending order
C.	Data of id will be sorted in descending order
D.	All of above
E.	None of these
Answer» D. All of above

Discussion

No Comment Found

Related MCQs

Is there any error in the following query? <pre class="prettyprint lang-c">SELECT emp_id, title, start_date, fname, fed_id FROM Employee ORDER BY 3, 4; </pre>
Is there any error in the following query? <pre class="prettyprint lang-c">SELECT emp_id, title, start_date, fname, fed_id FROM Employee ORDER BY LEFT (fed_id, 5); </pre>
Is there any error in the following query? <pre class="prettyprint lang-c">SELECT emp_id, title, start_date, First_name, fed_id FROM Employee ORDER BY RIGHT (fed_id, 3); </pre>
If id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query? <pre class="prettyprint lang-c">SELECT id FROM student ORDER BY id ASC; </pre>
If id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query? <pre class="prettyprint lang-c">SELECT id FROM Student ORDER BY id DESC; </pre>
What is the significance of ORDER BY emp_id ASC in the given query? <pre class="prettyprint lang-c">SELECT id, First_name, Last_name FROM Student ORDER BY id ASC; </pre>
What is the significance of ORDER BY emp_id DESC in the given query? <pre class="prettyprint lang-c">SELECT id, First_name, Last_name FROM Student ORDER BY id DESC; </pre>
What will be the order of sorting in the given query? <pre class="prettyprint lang-c">SELECT emp_id, emp_name FROM Employee ORDER BY emp_id, emp_name; </pre>
What is the significance of ORDER BY in the given query? <pre class="prettyprint lang-c">SELECT emp_id, fname, lname FROM Employee ORDER BY emp_id; </pre>
If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the given query? <pre class="prettyprint lang-c">SELECT id FROM Student ORDER BY id; </pre>

What is the significance of ORDER BY emp_id DESC in the given query?SELECT id, First_name, Last_nameFROM StudentORDER BY id DESC;

Discussion

No Comment Found

Related MCQs

Reply to Comment

What is the significance of ORDER BY emp_id DESC in the given query?
SELECT id, First_name, Last_name
FROM Student
ORDER BY id DESC;