SELECT * FROM (SELECT ROWNUM DD, M.* FROM (SELECT SAL FROM EMP order by

how to calcuate the second highest salary of he employee

Question Posted / sachin s. patil

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

Please Help Members By Posting Answers For Below Questions

what does the t-sql command ident_current does? : Transact sql

1048

What is informix sql?

1032

how to see the create table statement of an existing table? : Sql dba

1060

what are local and global variables and their differences? : Sql dba

1136

How delete a row in sql?

1042

What is bulk compiling in pl/sql.?

1191

explain advantages of innodb over myisam. : Sql dba

1175

How many types of primary keys are there?

1080

Which type of cursor is used to execute the dml statement?

995

What is the unique index?

1110

Does pl sql work in mysql?

1035

What are expressions?

1062

What is use of trigger?

987

what is text? : Sql dba

1120

Can a trigger call a stored procedure?

1128