Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134827 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
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
Can we use update in sql function?
How do you declare a user-defined exception?
How many sql statements are used?
What does pl sql developer do?
How many types of primary keys are there?
What is the difference between syntax error and runtime error?
Is sql microsoft?
What are the ddl commands?
how to get help information from the server? : Sql dba
Does sql*plus have a pl/sql engine?
What is full join?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How would you pass hints to the sql processor?
What are stored procedures in mysql?
how is myisam table stored? : Sql dba
