Interested to Buy Any Domain ? << Click Here >> for more details...
how can i fetch the records of 3 tables with a single select
query,without using join.
- 12 Answers
- 33966 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / kiran kumar.b
select max(sal) as sal from
(select max(sal) as sal1 from emp1
union
select max(sal) as sal2 from emp2
union
select max(sal) as sal3 from emp3)
salary order by sal desc
u can get the max sal from three tables lets try to do this
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
What is the difference between a pool table and a transparent table and how they are stored at the database level?
What is the difference between field-group header and other field groups? : abap modularization
What is the definition of modification in an sap system and how do they impact an upgrade?
Hat are the different types of mode (run code) in call transaction method?
What are the different modules of sap? : sap abap hr
What is design pattern? Provide example .Why are we using it?
What is the difference between skip and new-line?
How does the interface between the dynpro and the abap/4 modules take place?
where are the passwords for ITS stores?
What is the modification assistant?
What two statements would be used to exchange data between programs using abap memory?
Name a few data dictionary objects? : abap data dictionary
How do you connect to the remote server if you are working from the office for the client in remote place?
What is meant by stacked list?
– Programming using BAPI : Create Debit Memo Request (DMR) with reference to Sales Order and update the delivery number and PO number in the newly created DMR. Send the spool of the report by E-mail if the E-mail option is enabled. Selection Screen Required: Sales Org Delivery type Sales document type Optional: Planned Goods movement date Option to choose E-Mail E-mail Address Output device Output Output should display both successful and unsuccessful creation of DMR with the following fields, Success/Error (S/E) Sales Document number Delivery number New Debit memo request number Error message Tables TVAK, TVCPA, VBAK, LIKP, LIPS
