Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134541 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
What is the default isolation level in sql server? : Transact sql
Can we join more than 2 tables in sql?
What is pivot query?
What are the different sql languages?
What are instead of triggers?
Explain what is a subquery ?
how do you login to mysql using unix shell? : Sql dba
What is a subquery in sql?
How does an execution block start and end in pl sql?
Differentiate between sga and pga.
what is log shipping? : Sql dba
what is the difference between join and union? : Sql dba
How do I partition in sql?
How to make a copy values from one column to another in sql?
What is mdf ldf and ndf?
