You want a single output by comining two or more queries. How would you do that?
- 1 Answers
- 951 Views
- I also Faced
- E-Mail Answers
Answer / Shtakshi Bhatnagar
To combine multiple SQL queries into a single output, one approach is to use the UNION operator. The UNION operator combines the results of two or more SELECT statements by returning a single table containing rows from all result tables in the order they appear in the query. Here's an example:
(SELECT column1 FROM table1)
UNION
(SELECT column1 FROM table2)
| Is This Answer Correct ? | 0 Yes | 0 No |
Which events get fired after db update?
What are various ways to trace a process / application in peoplesoft?
what could be the reason when CPU utilization is high when no load on app server? a. unidentified memory leakage in the server b. more psappsrv processes in the app server c. File system is full d. all of the above
What are the ae program options?
What event gets fired after DB Update?
how Can i check processing consuming by peoplesoft applications?
Explain state records. What is its purpose?
How can you launch psadmin?
Explain environment hub?
How would you set up table-sharing in peopletools applications?
Which commands can be run in Bootstrap mode?
you have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?
PeopleSoft HRMS 
