Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 136465 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / carol
unique is a constraint on coloumnsbut distinct is used in DML for query retrieval in select
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain how can you save or place your msg in a table?
what is the difference between join and union? : Sql dba
Which one is better sql or oracle?
What does (*) mean in sql?
Explain correlated query work?
What are sql queries used for?
What is the difference between left join and right join?
What is the location of pre_defined_functions.
explain advantages of myisam over innodb? : Sql dba
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is break?
Are subqueries faster than joins?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How to convert comma separated string to array in pl/sql?
Define commit?
