πŸ“Š MySQL
Q. If emp_id contain the following set {1, 2, 2, 3, 3, 1}, what will be the output on execution of the following MySQL statement?
SELECT emp_id
FROM person
ORDER BY emp_id;
  • (A) {1, 1, 2, 2, 3, 3}
  • (B) {1, 2, 3, 3, 2, 1}
  • (C) {2, 2, 1, 1, 3, 3}
  • (D) None of the mentioned
πŸ’¬ Discuss
βœ… Correct Answer: (A) {1, 1, 2, 2, 3, 3}

Explanation: This question tests your understanding of how the ORDER BY clause works in MySQL.

Explanation by: Ranjeet
This question tests your understanding of how the ORDER BY clause works in MySQL.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
68
Total Visits
πŸ“½οΈ
11 mo ago
Published
πŸŽ–οΈ
Ranjeet
Publisher
πŸ“ˆ
85%
Success Rate