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
What is the usage of when clause in trigger?
what are the advantages of using stored procedures? : Sql dba
What is a temporal data type?
what is 'mysqlshow'? : Sql dba
What is sql*plus?
What are pl/sql packages?
can sql servers linked to other servers like oracle? : Sql dba
What do you mean by query optimization?
What is the difference between partition and index?
what are enums used for in mysql? : Sql dba
List the various privileges that a user can grant to another user?
what is the difference between join and union? : Sql dba
What is pl sql in oracle?
How do I send sql query results to excel?
What are the benefits of stored procedures?