Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134586 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
How you improve the performance of sql*loader? : aql loader
What is the location of pre_defined_functions.
What are the possible values for the boolean data field?
What are the differences between implicit and explicit cursors?
How do I view stored procedures?
How to use sql*plus built-in timers?
Can we use ddl commands in pl sql?
what are wild cards used in database for pattern matching ? : Sql dba
what is the difference between where clause and having clause? : Sql dba
How do you change a value in sql?
What is the sql case statement?
what is the difference between join and union? : Sql dba
Can we insert in view in sql?
What is offset and limit in sql?
How can we store rows in PL/SQL using array?
