how to get second highest salary from a employee table and how get a 5th highest salary from a employee table?
11 37339Valuation of Goodwill and calculation!! question asked in many companies,try to remember the methods..
1 10340I 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 4262Post New Amex Interview Questions
What is aggregator module?
What is the quickest way to open an ubuntu terminal in a particular directory?
Explain branch testing?
What does std mean in c++?
How do I assign a hostname to a windows ip address?
How does thread synchronization occur in a monitor?
Why PS class CT is always preferred for Differential protection?
Why do you want to be an accountant?
If fspc(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both ci and ca are specified to be empty?
What are the four characteristics of algorithms?
How can you integrate css on a web page?
Define damping ratio.
What is the meaning concurrency in the db2 database?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What are the central interfaces of the R/3 system?