Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135497 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
what are the advantages of sql ? : Sql dba
what is a stored procedure? : Sql dba
How do I send sql query results to excel?
What is the difference between syntax error and runtime error?
i have some prob lem to tell me about my self in interview first round ...
what is the difference between join and union? : Sql dba
How do you copy a table in sql?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What is varchar used for?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Why is the cursor important?
What is sql engine in oracle?
Do we need commit after truncate?
What is difference sql and mysql?
Can two tables have same primary key?
