select salary from table order by salaray desc limit 1,1

How to Select second Maximum salary in a Table ?

Question Posted / ranjith

Answer Posted / ranjith

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to write a query with a right outer join in oracle?

1110

What are the different types of trigger and explain its various uses and functions?

1008

What is bulk load in oracle?

1005

what is the difference between restoring and recovering?

962

What is meant by raw datatype?

1003

How to create a temporary table in oracle?

1191

What are the roles of dba?

1018

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1943

please explain.. DB architecture ...

1966

What is where clause in oracle?

981

What is a table index?

1012

what are archived logs?

2142

How to initialize variables with default values?

1158

How to write a query with an inner join in oracle?

973

Difference between oracle's plus (+) notation and ansi join notation?

1031