select max(salary) from emp_salary where salary<(select max(salary) fro

how to get second highest salary in SQL(as/4000

Question Posted / sachin

Answer Posted / sachin

select max(salary) from emp_salary where salary<(select
max(salary) from emp_salary);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is meant by nl2br()? : Sql dba

1031

What is sql select statement?

1028

Explain the commit statement.

1151

What is the process of debugging?

1063

Does asenumerable execute the query?

1037

Is record in oracle pl sql?

956

What are different categories of sql commands?

1127

What are system versioned tables?

1020

what is foreign key? : Sql dba

1025

What programs use sql?

998

How do I restart sql?

963

Are sql connections encrypted?

1016

What do you mean by query optimization?

996

What is a dynamic query?

1016

Why do we use joins?

1033