Differences between UNIQUE and DISTINCT in select statements
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 primary key clustered index?
How much does sql cost?
what is the difference between a web-garden and a web-farm? : Sql dba
How can one get sql*loader to commit only at the end of the load file? : aql loader
what is union, minus and interact commands? : Sql dba
How to pronounce postgresql?
What are the advantages of pl sql?
What mean sql?
How many types of normalization are there?
What is dbo in sql?
What is cte sql?
what is meant by nl2br()? : Sql dba
Mention what pl/sql package consists of?
what are the different tables present in mysql? : Sql dba
Is ms sql is free?