find 2nd highest salary in sql [closed]

by

Use this query

SELECT 
    MIN(s.Payment), e.EmpName, e.EmpID 
FROM 
    dbo.Employee e 
INNER JOIN
    Salary s ON e.EmpID = s.EmpID
WHERE 
    e.EmpID IN (SELECT TOP 2 EmpID FROM dbo.Salary ORDER BY Payment DESC)

More Related Contents:

  1. incorrect syntax near keyword where [closed]
  2. Check if table exists in SQL Server
  3. How to get a float result by dividing two integer values using T-SQL?
  4. Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation
  5. Select columns with NULL values only
  6. Import Multiple CSV Files to SQL Server from a Folder
  7. Incorrect syntax near ‘GO’
  8. Effectively Converting dates between UTC and Local (ie. PST) time in SQL 2005
  9. Oracle: is there a tool to trace queries, like Profiler for sql server? [closed]
  10. SQL Server – Remove all non-printable ASCII characters
  11. Regular Expressions in SQL Server servers?
  12. Unique constraint on multiple columns
  13. Diagnosing Deadlocks in SQL Server 2005
  14. What is a simple command line program or script to backup SQL server databases?
  15. Disadvantages of MARS (Multiple Active Result Sets)?
  16. SQL Server Output Clause into a scalar variable
  17. Replace single quotes in SQL Server
  18. Why is sql server storing question mark characters instead of Japanese characters in NVarchar fields?
  19. sql use statement with variable
  20. How to create a yes/no boolean field in SQL server?
  21. How do I select last 5 rows in a table without sorting?
  22. displaying multiple records by using resultset
  23. How to display two digits after decimal point in SQL Server
  24. Copy table to a different database on a different SQL Server
  25. Include missing months in Group By query
  26. SQL Server equivalent to Oracle’s CREATE OR REPLACE VIEW
  27. In SQL Server, how can I find everywhere a column is referenced?
  28. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  29. Oracle sequence but then in MS SQL Server
  30. Convert float into varchar in SQL Server without scientific notation

Leave a Comment