Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 131220 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / gvmahesh
unique is a constraint it's declare for preventing the data
duplication.we create it along with table creation.
DISTINCT is a clause it is used for retrieving the data
without duplication.but it can't prevent the data
duplication.It just hiding the duplicated data.
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
What is offset in sql query?
what is normalization? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is data type in sql?
Can a trigger call a stored procedure?
Is sql a backend?
Is primary key is clustered index?
what is sql in mysql? : Sql dba
What is cte?
Which is faster union or join?
What are reports usually used for?
How many types of triggers are there in pl sql?
What is normalization in a database?
how would concatenate strings in mysql? : Sql dba
i have some prob lem to tell me about my self in interview first round ...
