Write a query to find second highest salary of an employee.
Answer Posted / saima
1.
SELECT * TOP 1 from
(Select Top 2 from employee Order By Salary desc)
order By salary desc
2.
SELECT * from
(Select Top 2 from employee Order By Salary desc)
where salary <max(salary).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of testing framework techniques?
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
Explain me what is a framework and what are the frameworks available in rc?
hi i would like to know is there any training institue for Calabash,robotium and ui automator in hyderabad...urgent
Stop automating the tests which run once?
Once you identify the tool what would be your next steps?
What all things can you automate?
List out some of the automation tools which could be integrated with selenium to achieve continuous testing.
What is open source tool and give example?
Do you know what is a data-driven framework?
How does load testing work for websites?
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
What are the different types of an automation tool that you are aware of?
how to use regular expression in Test Complete Functional tool
I want a code for a following item in TSL Language. Look up a person in database, If not found, add person to the database.