SQL QUERY

Query For Highest ,2nd Highest ,3rd Highest ,4th Highest  salary(only one Query)
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