Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134580 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 a trigger in sql?
Which are the different types of indexes in sql?
Is pl sql different from sql?
Can we use two order by clause in query?
What is a record in pl/sql?
Does mysql_real_escape_string prevent sql injection?
What are the uses of sysdate and user keywords?
Can procedure in package be overloaded?
How do I make sql search faster?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
How do you rank data in sql?
What is pl sql in dbms?
What is update query?
What is multiple columns?
What are the different sql languages?
