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
- 33781 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 user interfaces of interactive lists?
What is locking ?
What is an abap instance?
How do you populate data into a multiple line field?
In which time constraint does the infotype records depend on the subtype ? : abap hr
How to create any functions?
Explain how to create any functions?
How many primary keys can be created for a table?
What are the types of bdc s?
Explain what are the different functions used in sap script? What are the parameters used in each function?
What is difference between dialog program and a report?
In a loop of an internal table, what is the use of at first & at last statements?
Type casting and error handling
What are the different message types available in the abap/4 ?
How do you work with semi colon se[arated files in BDC ?
