πŸ“Š MySQL
Q. If in Table "employee", a column "emp_id" consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?
SELECT DISTINICT emp_id
FROM employee;
  • (A) {1,2,2,3,3,5,6,7,8,8}
  • (B) -indexes
  • (C) { }
  • (D) None of the mentioned
πŸ’¬ Discuss
βœ… Correct Answer: (B) -indexes

Explanation: This question is about how MySQL's DISTINCT keyword works.

Explanation by: Ritu Nagar
This question is about how MySQL's DISTINCT keyword works.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
78
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Ritu Nagar
Publisher
πŸ“ˆ
82%
Success Rate