Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 131489 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 data manipulation language?
What are field types?
What is mdb stand for?
Explain the advantages and disadvantages of stored procedure?
What is a boolean in sql?
What is a natural join sql?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
how can we know the count/number of elements of an array? : Sql dba
Why indexing is needed?
what are different types of collation sensitivity? : Sql dba
how to create a test table in your mysql server? : Sql dba
Why do we use partitions in sql?
What is right join in sql?
What are sql procedures?
What is a stored procedure in sql with example?
