Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 28038 Views
- I also Faced
- E-Mail Answers
Answer Posted / versaites
select top 1 emp_total_sal,emp_name from (
select top 2 emp_total_sal,emp_name from employee_table
ORDER BY emp_total_sal DESC) a
ORDER BY emp_total_sal ASC
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
describe transaction-safe table types in mysql : sql dba
What are the different sql languages?
Can we change the table name in sql?
what is a table in a database ? : Sql dba
What is row_number () in sql?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Does view contain data?
What are the differences between implicit and explicit cursors?
Why is the cursor important?
Is clustered index a primary key?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Define concurrency control. : Transact sql
What are expressions?
what is meant by urlencode and urldocode? : Sql dba
What is insert command in sql?
