MySQL Database MCQs - CSE MCQs Questions and Answers

Home / CSE MCQs / MySQL Database MCQs :: Discussion

If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the given query?

SELECT emp_id

FROM person

ORDER BY emp_id;

{-3, -2, -1, 1, 2, 3}

{-1, 1, -2, 2, -3, 3}

{1, 2, 3, -1, -2, -3}

None of the mentioned

Answer : Option A

Explanation :

"ORDER BY clause sort the emp_id in the result set.

Be The First To Comment

Comments

Name