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

What is the usage of when clause in trigger?

785


what are the advantages of using stored procedures? : Sql dba

845


What is a temporal data type?

800


what is 'mysqlshow'? : Sql dba

783


What is sql*plus?

801


What are pl/sql packages?

796


can sql servers linked to other servers like oracle? : Sql dba

772


What do you mean by query optimization?

770


What is the difference between partition and index?

691


what are enums used for in mysql? : Sql dba

856


List the various privileges that a user can grant to another user?

795


what is the difference between join and union? : Sql dba

750


What is pl sql in oracle?

812


How do I send sql query results to excel?

798


What are the benefits of stored procedures?

745