Query For Highest ,2nd Highest ,3rd Highest ,4th Highest salary(only one Query)
For Highest Salary Of a Employee :
For 2nd Highest Salary Of a Employee :
Display All Data of a Table :
Count Number of Columns (Fields) In a Table :
select MAX(salary) from Employee where salary not in(select DISTINCT top 0 salary from Employee order by salary desc )Change 0 to 1 for 2nd highest ,2 for 3rd highest salary, like this you can change.
For Highest Salary Of a Employee :
Select MAX(Salary) From EmployeeTable;
For 2nd Highest Salary Of a Employee :
SELECT MAX(Salary) FROM EmployeeTable WHERE Salary NOT IN (SELECT MAX(Salary) FROM EmployeeTable )
Find the nth highest salary using the TOP keyword in SQL Server :
SELECT TOP 1 Salary
FROM (
SELECT DISTINCT TOP N Salary
FROM EmployeeTable
ORDER BY Salary DESC
) AS Emp
ORDER BY Salary
Join Query for Multiple Tables :
SELECT State , DistName,SubDistName
FROM StateTable
inner join DistrictTable
on StateTable.StateCode=DistrictTable.StateCode
Display All Data of a Table :
SELECT * from TableName;
Count Number of Columns (Fields) In a Table :
SELECT Count(*) FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'Name Of your Table'
No comments:
Post a Comment