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
- 34647 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
how 2 create the normal form by using functional module
What is design pattern? Provide example .Why are we using it?
What is the relationship existing between the various data elements in data dictionary? : abap data dictionary
How can you access the function code from menu painter?
What is a database view? : abap data dictionary
Can i Have Some Realtime Examples On Modulepool programming.
What is gui status? How to create /edit gui status?
how to read the standard field value in your custom program.
I am trying to automate a manual processing of iDOCs in BD87. I used the following code to pass idoc-id to global variable 'DCN' and then skip the first screen of BD87 to go to processing directly. After running this code SET PARAMETER ID 'DCN' FIELD itabhdr-idoc_id. CALL TRANSACTION 'BD87' AND SKIP FIRST SCREEN. it takes me to the first screen because it cannot recognize my idoc-id. How I can pass idoc-id to global? I have used the above code to goto VA02 with VBELN and it worked perfectly.
What are the features of abap/4 dictionary? : abap data dictionary
How many lists can a program can produce?
What are lock objects?
List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr
What are client dependant objects in abap/sap?
What are match codes? describe?
