Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 131264 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / hemasundar
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.But, nearly both are same...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the command used to fetch first 5 characters of the string?
How does pl sql work?
How to execute a stored procedure?
what is query cache in mysql? : Sql dba
What are the different types of triggers?
What is the difference between drop and truncate commands?
How do I create an index in word?
What is difference between mysql and postgresql?
What is cursor in pl sql with examples?
Why are aggregate functions called so?
Is pl sql and postgresql same?
What is difference between joins and union?
What is the difference between pl and sql?
What is oracle and pl sql?
Does view contain data?
