Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135491 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 are keys in sql?
What programs use sql?
What is the difference between clustered and non-clustered indexes?
How does index help in query performance?
What is bind variable in pl sql?
Explain foreign key in sql?
What is cascade in sql?
Can we use pl sql in mysql?
what is a control file ? : Sql dba
What are the possible values that can be stored in a boolean data field?
How to test for null values?
What are functions in sql?
Is sql low level language?
How to display Row Number with Records in Oracle SQL Plus?
What is transaction control language (tcl)?
