select max(sal) from table_name where sal<(select max(sal) from table

how to find the second highest salary from emp table?

Question Posted / kishor dange

Answer Posted / kishor dange

select max(sal) from table_name where sal<(select max(sal)
from table_name)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I view tables in mysql?

986

Does truncate release storage space?

1077

What is package in pl sql?

1027

Can we use ddl statements in stored procedure sql server?

1011

What is sql injection owasp?

1065

What is an inconsistent dependency?

1046

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1082

What is trigger types of trigger?

1069

What is java sql package?

1097

What is native sql query?

1025

What is the process of debugging?

1070

Do stored procedures prevent sql injection?

968

What is difference between sql and oracle?

1130

What does plv msg allows you to do?

1142

How do you pronounce sql?

1013