Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 136365 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 bind variable in pl sql?
List the ways to get the count of records in a table?
What is pl/sql table? Why it is used?
How do you get column names only for a table (sql server)?
Is sql a scripting language?
What is pl sql and why it is used for?
How do sql triggers work?
what are the different type of normalization? : Sql dba
What is sharding in sql?
What is scope of pl sql developer in future?
what is cross join? : Sql dba
Why plvtab is considered as the easiest way to access the pl/sql table?
What is java sql connection?
How many tables can you join in sql?
What is vector point function?
