how can i fetch the records of 3 tables with a single select
query,without using join.
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
Why do we use dynamic where conditions?
Update types in Call transaction method. What is the difference?
Explain the structure of a bdc sessions?
Explain different types of locks?
What is the reserve command?
what are the 2 other types of views, which are not allowed in release 3.0? : abap data dictionary
Lock objects and what are parameters of ENQUEUE FM?
What is the difference between the function module and a normal abap/4 subroutine? : abap modularization
How do you write a function module in sap?
What is a view in sap? : abap data dictionary
What is the use of the raising exception? : abap modularization
What are the basic objects of the data dictionary? : abap data dictionary
Is it possible to pass data to and from include programs explicitly? : abap modularization
What are pool tables?
Explain what is the step-by-step process to create a table in data dictionary?