Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 28095 Views
- I also Faced
- E-Mail Answers
Answer Posted / gyana ranjan behera
select ename,sal.rn from(select ename,sal,rownum rn from(select ename,sal from emp order by sal desc))where rn=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what does the t-sql command ident_current does? : Transact sql
What is a primary key sql?
Can triggers stop a dml statement from executing on a table?
Are stored procedures faster than queries?
How to pronounce postgresql?
Is sql microsoft?
How do I find duplicates in sql?
What is the command used to fetch first 5 characters of the string?
What is difference between pls_integer and integer?
What are the different types of dbmss?
What is trigger and stored procedure in sql?
how can you see all indexes defined for a table? : Sql dba
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What are the indexing methods?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
