select * from employees where salary = (select mnin(salary)from (select s

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

Question Posted / aarti

Answer Posted / aarti

select * from employees
where salary = (select mnin(salary)from (select salary from
employees where rownum <= 2 order by salary DESC)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Tell us can we find all links on a web page?

992

What is testng and why is it better than junit?

1050

Which is the best place to learn Loadrunner performance testing in hyderabad ?

1540

What is junit annotation?

1030

what are the steps followed in unit testing, system testing, integration testing

2048

What is data - driven automation?

2665

What is hybrid automation?

1023

How automation process is carried out?

1026

is anybody suggest me which one is the best testing institute in ameerpet hydrabad

2165

Where to maintain information like login, password and url?

922

How would you test your own element locator?

1021

What are the 5 common software development problems solutions?

1016

Tell us the line of code webdriver driver = new firefoxdriver();.?

923

What is tree view in automation testing?

978

Explain what is the hybrid framework?

998