Write a query to find second highest salary of an employee.
- 72 Answers
- 109252 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
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
Program/pseudo code on FIFO? Input a string and make sure that output is in FIFO manner. Eg, Enter 'John Dave' as input and output should be 'John Dave' not 'Dave John'. (inbuilt functions like push, pop were given)
Where to maintain information like login, password and url?
Can we find all links on a web page?
Name some of the commonly used automation testing tools that are used for functional automation.
how can i count the no of edit field in a page and fill the multiple edit field
What is the purpose of getoptions() method?
List out some of the automation tools which could be integrated with selenium to achieve continuous testing.
Hi All! Am new to Selenium and would really appreciate your help writing test cases for the following scenario: 1. Manually create 2 logins User A and User B on say, orkut.com or facebook.com. 2. Have User A invite User B as a friend. 3. Have User B accept the friend request. 4. Have User A post a comment on his own profile. 5. Have User B post a reply to that comment. 6. Each User logs out of his respective account. 7. Do not use Selenium IDE. 8. Use Selenium RC and Java.
What generally is the structure of a framework?
Can any one give information on "Content Disposition" in TEST COMPLETE automation tool? mail me to pdamarakonda@smart-bridge.co.in call me to 09849423932
Do you know what is the purpose of deselectall() method?
I want to test a mobile software by an automation tool which is a IP telephony based software designed for both ios and android phone, basically this apps is develop for make call though few low cost audio codecs from Aircraft to Ground and Ground to Aircraft so anyone can suggest me which testing tool we can use for it
Elaborate the scripting standard while executing testing
What criteria do you consider for automating a test?
What are the advantages of automation testing?
