how to get second highest salary from a employee table and how get a 5th highest salary from a employee table?
11 35243Valuation of Goodwill and calculation!! question asked in many companies,try to remember the methods..
1 9777I 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 3637Post New Amex Interview Questions
How to dump a table from a database.
What is escape data in php?
What are the bits that support the demand paging?
Difference between LEN() and DATALENGTH() in sql server ?
What is the uses of html?
How do you autoshape in powerpoint?
What is the difference between list and tuples?
What is pluck method in laravel?
Explain the skinny table. What are the considerations for skinny table?
what is difference between view and Dip.
Explain broadcast receiver component of android?
How to use session under class file of APP_Code folder?
Define gathers?
Is there any thread in our .net programs?
What is difference between spring and hibernate?