Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 27743 Views
- I also Faced
- E-Mail Answers
Answer Posted / senorita
select ename,salary from (select rownum,ename,salary from
emp
order by desc) where rownum=2;
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is scalar data type in pl sql?
what are the advantages of sql ? : Sql dba
How do I send sql query results to excel?
how to do backup entire database? : Transact sql
Which sql statement is used to return only different values?
Which command is used to delete a trigger?
How delete all data from table in sql?
How to use distinct and count in sql query? Explain
How to Declare Fixed Length String Value In PL SQL
what is an extent ? : Sql dba
What is data types in sql?
What is microsoft t sql?
Why is theta join required?
What is out parameter used for eventhough return statement can also be used in pl/sql?
what does the t-sql command ident_current does? : Transact sql
