Interested to Buy Any Domain ? << Click Here >> for more details...
how to calcuate the second highest salary of he employee
- 13 Answers
- 18967 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
How do you modify a trigger?
What are all the different normalizations?
What is the use of <> sql?
What is pls integer?
What is java sql driver?
Can we use loop in sql?
How we can update the view?
What is aggregate function in sql?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Is primary key clustered or nonclustered?
what is a database lock ? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
Sql technical questions
Why partition by is used in sql?
