how to get second highest salary from a employee table and how get a 5th highest salary from a employee table?
11 34170Valuation of Goodwill and calculation!! question asked in many companies,try to remember the methods..
1 9547I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
2 3406Post New Amex Interview Questions
What is class and object c#?
What do you mean by beep?
what is the use of bean managed and container managed with example?
What is ejb container?
What is data hiding in python?
What is progress open edge?
Give an example when you had a clash with your peer. What did you do in that situation?
Can you name some popular machine learning algorithms?
What term is most commonly used to refer to the actual motion that stars have in relation to each other, and over many years will lead to changes in the shapes of constellations?
Can we have any code between try and finally blocks?
How will you copy a file from one machine to other?
What is zero of the system?
What are the main differences between parsimony,distance and likelihood-based algorithms?
What is different between resistance grounding system and resistance earthing system?
Describe the different styles of function prototypes in C++.