select salary from table_name where salary <(select salary from table

how to find the second highest salary from emp table?

Question Posted / shiva

Answer Posted / shiva

select salary from table_name where salary <(select salary
from table_name);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why do we use function in pl sql?

1011

what are the differences between binary and varbinary? : Sql dba

978

When is the explicit cursor used ?

981

What does count (*) do in sql?

954

What is column?

941

How do I install microsoft sql?

984

does sql support programming? : Sql dba

993

What is exit statement?

959

Explain the steps needed to create the scheduled job?

969

Is grant a ddl statement?

856

How to select all records from the table?

1069

What is the use of double ampersand (&&) in sql queries? Give an example

1082

What are different functions in sql?

899

What is pragma in sql?

1022

What is procedure and function in sql?

930