Write a query to find second highest salary of an employee.
Answer Posted / murlidhar
select * from emp A where 2=(select count(*) from emp B
where A.sal < B.sal)
| Is This Answer Correct ? | 41 Yes | 36 No |
Post New Answer View All Answers
What is a framework and what are the frameworks available in rc?
Tell us how can we handle web-based pop-up?
Hi I need the following information about JMeter 1) How many(max) threads(users) can hit the website using Jmeter? 2) How long(in hours) can we run Jmeter for stress test? (Is there any “Memory full” issue if we run for long time?) 3)What typeof sampler to use for clicking on the link?
Tell me what is the purpose of getoptions() method?
Is automation testing in agile methodology useful or not?
what is the difference between Batch test runner and framework ?
can anyone suggest me any low cost tool that can support both Manual and Automation testing ?
Manually in a page 10 check boxes is there.so 5 check box "on" and 5 check box "off" so using descriptive program how to know how many "on" and how many "off" plz help me this question answer?
What are the most popular tools for automation testing?
Hi, I want to learn DataBase Testing. So please some document or path so that i can get some material on DataBase Testing concepts (preferably SQL Server 2000). Thanks in advance, Guru
Tell me which web driver implementation is the fastest?
Explain me what is a framework and what are the frameworks available in rc?
How the object properties will be recognised by the tool If the functions/ statements are written manually?
Which protocol cam be used to makw jdbc connection woth loadrunner
Generic function for selecting a Radio Button in a Dialog