Select * from emp where sal=(select Max(sal) from emp where sal<(selec

Given an employee table, how would you find out the second
highest salary?

Question Posted / sowjanya

Answer Posted / sowjanya

Select * from emp where sal=(select Max(sal) from emp where
sal<(select Max(Sal) from emp)

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can an extended stored procedure be called from inside a user-defined function?

1055

Who are end users in dbms?

990

Explain about relational operator join?

1039

Explain about the relational database?

1073

What is an application role and explain a scenario when you would use one?

1012

Explain what a database is?

1047

How is data stored in dbms?

958

How to use timestamp datatypes

2039

Write the fastest query to find out how many rows exist in a table?

1117

What are the 18 schemas?

1121

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2857

What is a database development?

964

How you can make a parameterized view?

1012

What is data modeling with example?

998

Explain the rollup operator?

1076