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

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

Question Posted / prem

Answer Posted / prem

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you identify the test cases which are suitable for automation?

1042

What is difference between selenium and QTP tools Which is best tool... Which is most used tool

1392

Is ui level testing possible?

990

Tell me what is regression testing?

1026

What is open source tool and give example?

996

How to integrate Rational functional Tester with Rational Quality manager. Can anyone provide the details steps giving explaination with examples.

2035

Tell me what is automation testing?

1014

What are the primary features of good automation tool ?

1031

Tell me how can the user get a text of a web element?

948

Tell me how a text written in a text field could be cleared?

925

Write a short compiled module which selects random numbers?

1059

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

1904

Stop automating the tests which run once?

1060

Explain load testing on websites?

1052

What are the advantages of the automation framework?

974