Write a query to find second highest salary of an employee.
Answer Posted / muralidhara(minchu)
Select * from epm A where &(n-1)=(select count(*) from emp
B where A.sal < B.sal);
Try this it will work,this will give nth salary ie if u
enter 2 this will give second highest sal
| Is This Answer Correct ? | 13 Yes | 22 No |
Post New Answer View All Answers
Do you think that testing can be done only at the ui level?
hi to all, if we open a browser(for ex. yahoomail.com) using navigate command. the cursor by default focussing on the 'yahoo id' html edit box. how to get the label(ie.,yahoo id) of that html edit box using descriptive program. here we should not use identify tool to get the property,thtml editbox method. by tracing the cursor position we have to get the label name. is it possible? please let me know.
What is test driven development?
Any kind of test which you think should not be automated?
What are the differences between open source tools, vendor tools, and in-house tools?
Explain me how do you send enter/tab keys in webdriver?
hi every one this is ashok pls any one give answer me pls question is while testing with selenium after giving id user name and password , the inbox will be open , how to handle this one
On what factors can you map the success of automation testing?
Tell me what is intellij?
Tell me what type of scenarios can be automated?
how to test an webbased application?
What is in-house tool?
can any one please tell me QTP 9.2 supports which version of IE and Mozilla firefox.
Do you know how to check if a button is enabled on the page?
Can any one give me the script for drag and drop or setselection functions ?like in a not pad i want to select 5 lines