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

Write a query to find second highest salary of an employee.

Question Posted / harikrishna ravipati

Answer Posted / harikrishna ravipati

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Tell us what methods of robot class do you know?

1030

What are different coverages in function testing?

1201

Tell me what is regression testing?

1107

What are the 5 common software development problems solutions?

1064

What are the main attributes of test automation?

2055

wat would be the -ve test case for search where u can brak it ,tell dnt tell abt spl characters insertion ,boundary values chk.

1959

What is test automation or automation testing?

1020

Give some examples for defect management tools?

1111

What is a framework for automation testing?

1148

Write a short compiled module which selects random numbers. and what function is used to call your customized compiled module?

1017

what is the advantage and dis-advantages of using framework ?

2290

How do you plan test automation?

2041

How do we Test the C++ and Unix Application Using Automated Tool.

2570

How can we make one test method dependent on other using testng?

1056

Tell me what is tsl? What 4gl is it similar too?

1087