Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135451 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
Is sql considered coding?
What is view? Can we update view
What is record in pl sql?
What is the default isolation level in sql server? : Transact sql
What are triggers in sql?
How to create your own reports in sql developer?
How many scalar data types are supported in pl/sql?
What are the different types of joins in sql?
What is java sql connection?
What are different types of tables in sql?
What is the use of index in sql?
Is left join same as inner join?
How to get help at the sql prompt?
Is pl sql a programming language?
What is int identity in sql?
