Differences between UNIQUE and DISTINCT in select statements
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 recursive join in sql?
How do sql databases work?
What is sql used for?
Can we call a function containing dml statements in a select query?
What are the advantages of sql? Explain
Can a trigger call a stored procedure?
What is sql performance tuning?
Define concurrency control. : Transact sql
List out the acid properties and explain?
how can we find the number of rows in a table using mysql? : Sql dba
How do I run a program in pl sql?
Is a view faster than a stored procedure?
what are myisam tables? : Sql dba
How can you know that statistics should be updated?
What are pl sql data types?