Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 136386 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 left join example?
What is the purpose of using pl/sql?
What is record in pl sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is sequence in sql?
how to start mysql server? : Sql dba
What are the parts of a basic sql query?
Can there be more than one function with a similar name in a pl/sql block?
What are the advantages of stored procedure?
How can I change database name in sql?
what are the different type of sql's statements ? : Sql dba
What is composite primary key in sql?
What is sqlerrm?
What is %rowtype in pl sql?
What is the difference between delete, truncate and drop command?
