Q. Which SQL keyword is used to remove duplicate rows from the result set?

  • (A) REMOVE DUPLICATES
  • (B) DISTINCT
  • (C) UNIQUE
  • (D) DELETE DUPLICATE
πŸ’¬ Discuss
βœ… Correct Answer: (B) DISTINCT
Explanation: `DISTINCT` eliminates duplicate values from the result.
Explanation by: Mr. Dubey
`DISTINCT` eliminates duplicate values from the result.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
103
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Mr. Dubey
Publisher
πŸ“ˆ
90%
Success Rate