Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135679 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
What is a primary key? Explain
what is the different between now() and current_date()? : Sql dba
What are tables in sql?
What are the built in functions of sql?
What is difference between left and right outer join?
What is trigger point?
What is the difference between cluster and non-cluster index?
Is a secondary key the same as a foreign key?
How many postgresql users are there, worldwide?
What does closing a cursor do?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Which are the different character-manipulation functions in sql?
What's the procedure?
What is meant by user defined function?
What can sql server reporting services do?
