Differences between UNIQUE and DISTINCT in select statements
Answer Posted / pravin d. survase
UNIQUE is only used in oracle but,
DISTINCT is used in all RDBMS.
UNIQUE is used in SELECT statement and as KEY also.
DISTINCT is only used in SELECT.
DISTINCT KEY concept is not present in SQL/ORACLE.
UNIQUE also supress the duplicates but, UNIQUE KEY will
allow the duplicates.
DISTINCT supress the duplicates.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Who is the owner of mysql database?
What are different types of queries in sql?
Define select, insert, create, delete, update, drop keywords
What is bind variable in pl sql?
What is auto increment feature in sql?
What are all the common sql functions?
Which sql most popular?
Why do we use partitions in sql?
Is join an inner join?
How do I count duplicates in sql?
How to sort the rows in sql.
What is raw datatype in sql?
What are types of joins?
Where is all the data on the internet stored?
What is sql and how does it work?