Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134763 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / chandra sekhar
the diff between unique and distinct is
unique is applied before insertion and retrival.it consists
of non duplicate values.if unique constraint is given it
does not take duplicate values.distinct is used in retrival
it gives the suppressed row(ex if two rows are same it will
show single row and non duplicate row) therefore distinct is
the combination of suppressed duplicate and non duplicate rows.
| Is This Answer Correct ? | 35 Yes | 11 No |
Post New Answer View All Answers
Which is better stored procedure or query?
How is data stored on a disk?
What is the use of count (*) in sql?
What are some predefined exceptions in pl/sql?
What is pl sql collection?
How to create a menu in sqlplus or pl/sql?
What problem one might face while writing log information to a data-base table in pl/sql?
when is the use of update_statistics command? : Sql dba
What is sql lookup?
What is the difference between null value, zero, and blank space?
What is the difference between explicit and implicit cursors in oracle?
what is the use of double ampersand (&&) in sql queries?
how many sql dml commands are supported by 'mysql'? : Sql dba
What does the sign mean in sql?
Name some usages of database trigger?
