Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134529 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / manoj
UNIQUE(Constraint):- Can be only once for a column in a
table
DISTINCT(Clause):- Useed in select query to retrive distinct
(non repeated) data from table(s)
| Is This Answer Correct ? | 114 Yes | 68 No |
Post New Answer View All Answers
What is input buffer in sql*plus?
What is difference sql and mysql?
What does where 1/2 mean in sql?
What are user defined functions?
What packages(if any) has oracle provided for use by developers?
How to start the command-line sql*plus?
Difference between global and parameter variables?
Explain what is a view?
What is difference between inner join and cross join?
What is a procedure in pl sql?
Define implicit and explicit cursors.
What are triggers in sql?
What is mutating table error?
What are the types pl/sql code blocks?
Why is sql better than hql?
