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...

follwing scenario two table using find maximum salary?

table a table b
101 xxx 1000 106 6500
103 yyy 5000 108 800
104 din 6000 109 7000
105 dsh 200 110 3000

Answer Posted / murali udayagiri

select greatest(sub.emp_max_sal,sub.emp1_max_sal) from
(select (select max(sal) from emp) emp_max_sal,(select max
(sal) from emp1) emp1_max_sal from dual) sub;



Thanks,
Murali Udayagiri

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1514


How to extract the informatica rejected data?

1225


What is fact table? Explain the different kinds of facts.

1080


Define sessions in informatica etl?

1041


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2033


What is the use of code page?

1099


What is the Rank index port in Rank transformation?

1065


What are different types of transformations available in informatica?

997


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1085


Implementation methodology

1721


How to go to the older version for a mapping?

1103


What are the different versions of informatica?

1279


tell me about your project functionality

2348


What is the session task and command task?

1065


What are the performance considerations when working with aggregator transformation?

1157