Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2026 Crash Course
NEET 2026 Crash Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
251 views
in Structured Query Language by (31.4k points)
closed by

Distinguish the SQL keywords UNIQUE and DISTINCT.

1 Answer

+1 vote
by (30.9k points)
selected by
 
Best answer

1. Unique – It ensures that no two rows have the same value in a column while storing data. It is used with create command. 

2. Distinct – This keyword is used to avoid duplicate values in a column of a table while retrieving data. It is used with select command.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...