SQL Nth Highest

Utility to create the SQL query to get Nth Highest Value of a column of a Table.
Please enter TableName and Column name for Nth Highest value and press Submit button.

Step 1. TableName Step 2. ColumnName Step 3. Nth Value Step 4. Press Button

  
Example:
SELECT * -- Outer Query
FROM Employee Emp1
WHERE (N-1) = ( --Inner Query
SELECT COUNT(DISTINCT(Emp2.Salary))
FROM Employee Emp2
WHERE Emp2.Salary > Emp1.Salary)