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
- 33830 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 data types of internal tables?
What is client in the sap system? : sap abap hr
Give 3 scenario of reporting due to which you require reporting help of ABAP consultant?
What are the differences between transparent tables, pooled tables & cluster tables? : abap data dictionary
What is the max. No. Of structures that can be included in a table or structure? : abap data dictionary
What is the difference between semi-monthly and Bi-weekly payroll area
What do you mean by transparent tables in sap abap? : abap data dictionary
What is asynchronous and synchronous update?
In which time constraint does the infotype records depend on the subtype ? : abap hr
Does sap handle multiple languages?
What will happen when we use single buffered selected?
What work you have done in HR module
How many lists can a program can produce?
Name the special commands of list?
How do you read files from the application server ? : abap bdc
