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


Please Help Members By Posting Answers For Below Questions

Is primary key clustered index?

722


How much does sql cost?

782


what is the difference between a web-garden and a web-farm? : Sql dba

801


How can one get sql*loader to commit only at the end of the load file? : aql loader

798


what is union, minus and interact commands? : Sql dba

915


How to pronounce postgresql?

818


What are the advantages of pl sql?

880


What mean sql?

770


How many types of normalization are there?

715


What is dbo in sql?

747


What is cte sql?

757


what is meant by nl2br()? : Sql dba

814


Mention what pl/sql package consists of?

766


what are the different tables present in mysql? : Sql dba

729


Is ms sql is free?

741