select max(salary) as second_highest from emp where salary

how to find the second highest salary from emp table?

Question Posted / karthik.k

Answer Posted / karthik.k

select max(salary) as second_highest from emp where salary
< (select max(salary) from emp)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are %type and %rowtype for?

1106

What is the use of procedures?

1014

What is auto increment?

1044

What is pl sql script?

1083

What are sql built in functions?

978

Is left join and outer join same?

1114

How is pl sql different from sql?

1142

Could you please provide oca (oracle 10g) dumps for my certification ?

5239

How many types of normalization are there?

1013

How does one load ebcdic data? : aql loader

1258

How many types of index are there?

1099

Describe sql comments?

1111

what is query cache in mysql? : Sql dba

1080

Which join is like inner join?

1087

What is the sql case statement?

1054