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
What is time constraint ? : abap hr
What is tcode se16?
Can i Have Some Examples on Enhancements.
What is the maximum number of structures that can be included in a table or structure
How many lists can a program can produce?
On abap: did you set up a workflow? Are you familiar with all the steps for setting up a workflow?
The data of a view is not physically stored, but derived from one or more tables (t/f) : abap data dictionary
A subroutine can contain nested form and endform blocks. State true or false. : abap modularization
Explain what is the purpose of sap script?
Differentiate between transparent tables, cluster tables and pooled tables
Explain the differences between sap memory and abap memory?
Can we reuse a userexit?
What are the fields in a bdc_tab table? : abap bdc
I am uploading 100 records out of which say 59th record has error so what will happen if I am using synchronous or asynchronous method of bdc? Can we update the database using local update mode how? : abap bdc
How to display or know if the value entered contains records or not?