Interested to Buy Any Domain ? << Click Here >> for more details...
how to calcuate the second highest salary of he employee
- 13 Answers
- 18588 Views
- Synechron, I also Faced
- E-Mail Answers
Answer Posted / sachin s. patil
SELECT SAL FROM
(SELECT ROWNUM DD, M.* FROM
(SELECT SAL FROM EMP order by sal desc )M)
WHERE DD=2/***HERE U CAN ADD ANY NUMBER (WHERE I PUT 2)
, U WILL GET HEIGHEST SALARY THAT POSITION *******/
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is materialized view in sql?
what is a database lock ? : Sql dba
Do ddl statements need commit?
What is transaction control language (tcl)?
What are different joins used in sql?
What is the usage of the distinct keyword?
How does postgresql compare to oracle/db2/ms sql server/informix?
How do I find duplicates in the same column?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What is dml with example?
What is mutating sql table?
give the syntax of grant and revoke commands? : Sql dba
Do foreign keys improve performance?
Explain lock escalation? : Transact sql
Are dml statements autocommit?
