Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135453 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / hemasundar
Distinct:Its gives only the non duplicate values in a database table.
Unique:The UNIQUE constraint uniquely identifies each record in a database table.its similar to primary key.these values
cannot be repeated.But, nearly both are same...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How will you distinguish a global variable with a local variable in pl/sql?
What is pl sql variable?
what are the features and advantages of object-oriented programming? : Sql dba
How does a trigger work?
Write an sql query to select all records from the table?
What is use of package in pl sql?
What are tuples in sql?
What is a constraint? Tell me about its various levels.
what is a database lock ? : Sql dba
how to rename an existing column in a table? : Sql dba
What is the source code of a program?
what is the difference between inner and outer join? Explain with example. : Sql dba
What is the difference between alter trigger and drop trigger statements?
Explain the order of sql statement execution?
How do you use a while loop in pl sql?
