Differences between UNIQUE and DISTINCT in select statements
Answer Posted / prabha
Distinct:
Its gives only the non duplicate values in a database table.
Unique:
The UNIQUE constraint uniquely identifies each record in a
database table.its similar to primary key.these values
cannot be repeated.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Mention what does the hierarchical profiler does?
Why truncate is faster than delete?
How do I count rows in sql?
What is the use of nvl function?
Which one is better subquery or joins?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is meant by temporal data?
what is a join? : Sql dba
What is sql lookup?
How do you use a while loop in pl sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Why do we create stored procedures & functions in pl/sql and how are they different?
Who developed sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
what are the 'mysql' command line arguments? : Sql dba