how can i fetch the records of 3 tables with a single select
query,without using join.
- 12 Answers
- 30454 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 are the disadvantages of different types of bdc's?
what is a text table ?
How many structures can be created in a Ztable ?
write a program for creation of customer quotation using BAPI 'BAPI_QUOTATION_CREATEFROMDATA'.
What is the difference between collect and append statements?
What is get cursor field?
How can we declare a table control in the abap/4 program?
Explain what is sequence of event triggered in report?
What are the types of data types in the sap abap?
What are the difference between tables and structures? : abap data dictionary
Is it possible to bring select option in module pool screens?
Differentiate between static and dynamic step loops?
What happens when you post goods issue after delivery? How does the inventory get reduced after the delivery?
Difference between Insert, Update and Modify?
What are the data types of the external layer? : abap data dictionary
