4
Reply

Find the 5th highest salary of employee.

    WITH Salaries AS (SELECT SalaryAmount, ROW_NUMBER() OVER(ORDER BY SalaryAmount DESC) AS 'RowNum'FROM dbo.SalaryTable ) SELECTSalaryAmount FROMSalaries WHERERowNum = 5

    1) C# doesn't support Multiple inheritance ( means deriving a class from more than one class)... If your application supposed to have more than one class features at a time, For ex : we can inherit one class and other interface as follows: Public class ChildClass : BaseClass, BaseInterface{ ................ }) An abstract class can have shared state or functionality. An interface is only a promise to provide the state or functionality. A good abstract class will reduce the amount of code that has to be rewritten because it's functionality or state can be shared. The interface has no defined information to be shared

    1) C# doesn't support Multiple inheritance ( means deriving a class from more than one class)... If your application supposed to have more than one class features at a time, For ex : we can inherit one class and other interface as follows: Public class ChildClass : BaseClass, BaseInterface{ ................ }) An abstract class can have shared state or functionality. An interface is only a promise to provide the state or functionality. A good abstract class will reduce the amount of code that has to be rewritten because it's functionality or state can be shared. The interface has no defined information to be shared

    Select Min(Salary) from ( Select top 5 Salary from table order by desc) T1