how to get second highest salary from a employee table and how get a 5th highest salary from a employee table?
11 34221Valuation of Goodwill and calculation!! question asked in many companies,try to remember the methods..
1 9556I 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 3414Post New Amex Interview Questions
What is marginal standing facility (msf)?
What are collection pools? What are the advantages?
What are the different types of an automation tool that you are aware of?
What is a tnc? Why do firms become transnational?
What are the different roles involved in the scrum framework?
Can we encode mathematics using XML?
How do I dual boot my pc?
What is malloc in c++?
What are the possible ways to gain information regarding the control file?
How do I open dll files to edit?
What are the types of custom settings in salesforce?
How scala is different from java?
. How do you analyse Inventory Shrinkages?
What is the purpose of abstract class?
Sketch the jacket cooling system?