how to get second highest salary from a employee table and how get a 5th highest salary from a employee table?
11 37630Valuation of Goodwill and calculation!! question asked in many companies,try to remember the methods..
1 10423I 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 4370Post New Amex Interview Questions
What is opsonisation?
What are three advantages of using functions?
Explain about the Standard strain with fimbriae of Klebsiella pneumoniae ?
What is the use of divider?
why you done mba in finance
When using mercury to recover very, fine gold from ore, define what is the best way to separate the gold laden mercury from the ore?
What will the ?getdate() function returns in PHP?
Mention what are the benefits of pl/sql packages?
Does facebook use php framework?
what is main difference between gsm & cdma
What are link in wordpress?
For crude application in floating roof tank, how to calibrate a DP Transmitter? How is the floating roof weight considered?
What are the restrictions apply to constructors and destructors?
What services use iis?
Mention what are the different compression techniques?