Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 28130 Views
- I also Faced
- E-Mail Answers
Answer Posted / vamana murthy
select ename,salary from emp
where rownum=2
order by salary desc
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What is the use of desc in sql?
What is the difference between nested table and varray?
How do I run sql profiler?
What are three advantages to using sql?
What does pragma mean?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
Why commit is not used in triggers?
how many sql dml commands are supported by 'mysql'? : Sql dba
how to check myisam tables for errors? : Sql dba
What is a clob in sql?
How many indexes can be created on a table in sql?
How to write pl sql program in mysql command prompt?
how can we find the number of rows in a table using mysql? : Sql dba
What is the use of <> sql?
