how to calcuate the second highest salary of he employee
Answer Posted / sachin s. patil
SELECT * FROM
(SELECT ROWNUM DD, M.* FROM
(SELECT SAL FROM EMP order by sal desc )M)
WHERE DD=2
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is a system versioned table?
What is varray in pl sql?
What is lexical units in pl sql?
What is cursor in pl sql?
What is sql prepared statement?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
What is a procedure in pl sql?
How do I access sql anywhere database?
Why do we use partitions in sql?
Does postgresql run on the cloud?
What is use of trigger?
Compare sql & pl/sql
What are the different types of tables in sql?
How can you create an empty table from an existing table?
What is consistency?