Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 136390 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
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
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What are different types of functions in sql?
Who developed sql?
how does a local variable is defined using t-sql? : Transact sql
What is sql exception?
What do you understand by pl/sql cursors?
what's the difference between a primary key and a unique key? : Sql dba
how to shut down the server with 'mysqladmin'? : Sql dba
How do you remove duplicate records from a table?
Does mysql support pl sql?
What is restrict in sql?
What is pl/sql table? Why it is used?
Explain the methods used to protect source code of pl/sql.
Can I learn sql in a week?
Can a procedure in a package be overloaded?
