Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135671 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
how to add a new column to an existing table in mysql? : Sql dba
What is normalization in a database?
What is varray in pl sql?
Are sql database names case sensitive?
how do you know if your mysql server is alive? : Sql dba
Does sql profiler affect performance?
Which join is like inner join?
Do we need to rebuild index after truncate?
What is oracle and pl sql?
Does truncate release storage space?
What is primary key and unique key?
What is error ora-12154: tns:could not resolve the connect identifier specified?
What is the difference between local variables and global variables?
What is trigger with example?
How many types of cursors are available in pl/sql?
