Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 130860 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / gourvendra singh
Buddy i dont found any difference in using distinct and
unique in the select statement, as both are performing same
operation in the select statement, almost every diff you
have discussed i want to add one that is u cant use
distinct in the create whereas unique u can.
| Is This Answer Correct ? | 19 Yes | 9 No |
Post New Answer View All Answers
how would concatenate strings in mysql? : Sql dba
What are the different ways to optimize a sql query?
How are sql commands classified?
How to return an array from java to pl/sql?
How many sql commands are there?
What is data types in sql?
Explain mutating table error.
Can you skip header records while loading? : aql loader
Why do you partition data?
Mention what is the use of function "module procedure" in pl/sql?
How does index help in query performance?
Why is sql*loader direct path so fast?
What is clustered and nonclustered index in sql?
how to use like conditions? : Sql dba
What is the maximum number of columns in sql table?
