Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

What is time constraint ? : abap hr

1282


What is tcode se16?

984


Can i Have Some Examples on Enhancements.

2464


What is the maximum number of structures that can be included in a table or structure

1057


How many lists can a program can produce?

1063


On abap: did you set up a workflow? Are you familiar with all the steps for setting up a workflow?

1012


The data of a view is not physically stored, but derived from one or more tables (t/f) : abap data dictionary

1304


A subroutine can contain nested form and endform blocks. State true or false. : abap modularization

1313


Explain what is the purpose of sap script?

1134


Differentiate between transparent tables, cluster tables and pooled tables

1109


Explain the differences between sap memory and abap memory?

974


Can we reuse a userexit?

1481


What are the fields in a bdc_tab table? : abap bdc

1105


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

3434


How to display or know if the value entered contains records or not?

1034