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

Answer Posted / saravanan.s

select max(salary) as salaryemp from employee where
employee.salary<(select max(salary) from employee)

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(

1775


wat would be the parameteries for ul testing for web applilcation

1695


Discuss the economics of automation and the role of metrics in testing.

2041


In Selenium how a test suit is run and report is generated.

1570


What do you think holds testers back to do automation? Is there a way to overcome it?

501






List down the primary features of a good automation tool?

520


Can you achieve 100% automation?

583


Can you do without a framework?

612


Tell us what is the difference between getwindowhandles() and getwindowhandle()?

508


When will you not automate testing?

608


Bug report formate in bugzilla

1629


What factors determine the effectiveness of automation testing?

545


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

1868


Hi vishal, Thanks for your reply... But i am not using Mozilla fire fox.. I am using IE 7.. Could you suggest me in this case.. I have tried with Rational tools which i am getting some installation problem and netvantage..tool....which i felt i can't write script for that.. please guide me in this..

1436


1. How would you Test & then automate an antivirus application? 2. How would u test & automate windows screen saver? (expected: "test scenarios" & "test approch": points)

1654