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 are packages in pl sql and also explain its advantages?
How do I find duplicates in sql?
How do you bind variables in pl sql?
what are rollup and cube in t-sql? : Transact sql
How do you optimize a stored procedure query?
what is the difference between where clause and having clause? : Sql dba
what is 'mysqlimport'? : Sql dba
What are the three pl sql block types?
Why having clause is used in sql?
Does pl/sql support create command?
What are sql commands?
What are triggers in sql?
How global cursor can be declare with dynamic trigger ?
What does the hierarchical profiler does?
What is the need of a partition key?