Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 127593 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
How can I get the number of records affected by a stored procedure?
tell me about various levels of constraint. : Sql dba
What are the two characteristics of a primary key?
what is cursor. write example of it. What are the attributes of cursor.
What are hotfixes and patches?
What is union and union all keyword in sql and what are their differences?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is partition by in sql?
Describe different types of general function used in sql?
How can you load multi line records? : aql loader
Which language is used in sql?
What is microsoft t sql?
what is the difference between join and union? : Sql dba
Can we insert delete data in view?
what is error ora-03113: end-of-file on communication channel?
