first find third maximum then it ll be very easy to find second maximum..

how to find the second highest salary from emp table?

Question Posted / raja

Answer Posted / raja

first find third maximum
then it ll be very easy to find second maximum.. :)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a sql profiler?

1023

what is the difference between truncate and drop statements? : Sql dba

1120

What is the usage of distinct keyword?

1065

What are the different datatypes available in PL/SQL?

1083

Explain table and field in sql?

1060

discuss about myisam key cache. : Sql dba

1019

Is sql microsoft?

1045

Does sap use sql?

988

What are the subsets of sql?

1130

What is union and union all keyword in sql and what are their differences?

1100

what are the type of locks ? : Sql dba

962

Is it possible to create the following trigger: before or after update trigger for each row?

1284

what tools available for managing mysql server? : Sql dba

1078

How to return an array from java to pl/sql?

1132

What is auto increment in sql?

1117