first find first maximum then easy to find second maximum

how to find the second highest salary from emp table?

Question Posted / jude

Answer Posted / jude

first find first maximum
then easy to find second maximum

Is This Answer Correct ?

98 Yes

330 No

Please Help Members By Posting Answers For Below Questions

Can we insert data into view?

903

When is the explicit cursor used ?

1035

How exception is different from error?

1019

Can you select everything, but 1 or 2 fields, without writer's cramp?

984

What is varchar sql?

1145

How do I start sql profiler?

997

How does rowid help in running a query faster?

1416

What does count (*) do in sql?

1016

What is an inner join sql?

1029

How to pronounce postgresql?

1058

Does sql require a server?

1018

what is the difference between where clause and having clause? : Sql dba

1000

What is pl sql collection?

970

How to assign sql query results to pl sql variables?

1081

What is sqlcontext?

1085