Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 130570 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / kapil deep
SELECT * FROM (SELECT * FROM emp_t WHERE ROWNUM < 3 ORDER
BY salary) WHERE ROWNUM < 2
above query work fine for oracle.
Taking 3 as N give u 3-1=2 i.e 2nd highest
4-1=3 gives u 3rd highest
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the Differnce between Client/Server Testing and Web Based Testing?
What are the things that one should consider for selecting a project for test automation? For example, stability, etc.
What are the differences between open source tools, vendor tools, and in-house tools?
Anyone aware of Test Runner (ETL Automation Testing tool) if so please help me with material in keerthi.smile14@gmail.com
I want to learn the data base testing, how can I start my psactice? I already reading the books of basic for data base? If any other books that make my study simple please suggest.
Explain how to perform load-testing?
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... :(
Explain me what are the main advantages of automation testing?
What are the steps to perform Load and Stress testing on a Website? What resources do I need to do this? Please advise. Thanks in advance.
Hi, Below is the code that i ran on selenium RC using eclipse IDE and java coding.: package source; import org.testng.annotations.BeforeSuite; import org.testng.annotations.Test; import com.thoughtworks.selenium.*; public class parameterized extends SeleneseTestCase { private Selenium browser; public static void main(String []args) { String arr[] = new String[5]; arr[0]= "bert"; arr[1]= "regular"; arr[2]= "copyonly"; arr[3]= "doert"; arr[4]= "inter"; parameterized obj = new parameterized(); obj.setUp(); obj.login_parameterize(arr); } @BeforeSuite public void setUp() { browser = new DefaultSelenium("localhost",4444, "*chrome", "http://goolge.com"); browser.start(); browser.open("http://goolge.com"); browser.waitForPageToLoad("30000"); browser.windowMaximize(); browser.open("/"); browser.click("gb_23"); } @Test public void login_parameterize(String[] arr ) { for(int i=0;i<=5;i++) { for(int j=0;j<=2; j++) { browser.type("//input[@id='Email']", arr[i]); browser.type("//input[@id='Passwd']", arr[i]); browser.click("//input[@id='signIn']"); browser.waitForPageToLoad("30000"); } } } public void EnterValuesIntoTextField_CheckWithGetValue() throws Exception { selenium.open("http://www.essaywriter.co.uk"); assertEquals("", selenium.getValue("id=textInput")); selenium.type("id=textInput", "Text In The Field"); assertEquals("Text In The Field", selenium.getValue("id=textInput")); } } When i ran this test i got an error which says: "Method login_parameterize requires 1 parameters but 0 were supplied in the @Test annotation." Any help is much appreciated. thank Gab
Can we prioritize tests in Junit. What is the sequence of execution in Junit?
How do you decide which tool you have to use?
It is a 30 days project & the client is in Singapur and we have to submit daily report regarding 1) What are the completed works, 2) What are the Pending Works ,3) Work planed for next day. You are free to assume regarding the project. can anybody help me to write an email to the client or Senior person who is staying in abroad
Can you list some other automation testing tools that you are familiar with?
What kinds of annotations are used in testng?
