What is set function in sql .E.g.What is difference between
union and union all
- 2 Answers
- 6534 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / veki
set operators are used to combine the out put of more than
one query.
union: used to combine the output Query1 and query2
and display them uniquely AND OUTPUT IS SORTED
ACCORDING TO FIRST COLUMN OF QUERY1
union all : it would combine the two query and displays then
as its duplicates AND HERE NO SORTING IS DONE.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Plz anybody send me Technical specification for AP Interface
what are the prerequisites for costing transactions?
In sequence i want to 11 and 15th values how we will write?
what are the balancing segments in AR?
tell me the scenarios of the independent in reports
Tell me how to find the custom directory in front end?
What is oracle soa suite?
can we use look up type instead of a pofile option?or valueset?is it possible how?
Do you know where we can check the status of po?
what is pay run id ?
What is sca and how is it useful?
What are the different components you should consider while defining a responsibility in oracle apps?
what is global tempory table?
What is a value set? List its various types.
What is oracle soa suite and what are its different components?
