Interested to Buy Any Domain ? << Click Here >> for more details...
What is set function in sql .E.g.What is difference between
union and union all
- 2 Answers
- 7951 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
How many schemas we have? how many you have used?
what is pay run id ?
Plz anybody send me Technical specification for AP Interface
What are the different components of soa suite?
where to define interorganization transaction charges and what are the different options?
Can you differentiate between mediator and osb?
what is global tempory table?
Do you know where we can check the status of po?
What is sca and how is it useful?
What is oracle soa suite?
What are do's and dont's of Interface?
What is count(*) from po_vendors(any table)?
How to create a purchase order without a requisition?
In support project one ticket alloted which steps follows manualy tell me ?
How to move the one file from one instance to another instance? And your scripts also?
