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

How can you create an empty table from an existing table?

1085

How can we link a sql database to an existing android app?

1036

What is data profiling in sql?

1085

What view means?

984

Is sql between inclusive?

1139

What is sql performance tuning?

927

What is scalar and vector?

1008

How does a trigger work?

1076

Explain what is sql*plus?

1149

Is grant a ddl statement?

904

What is an inconsistent dependency?

1051

Why is pl sql used?

990

Can we use joins in subquery?

1167

Can we group by two columns in sql?

1001

What is the difference between sql and mysql?

1124