Write a query to find second highest salary of an employee.

Answer Posted / ujwlala

select max(salary) from employee where salary<>(select
max(salary) from emp)

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what we have done after display the result in openSTA result pane.in the sense that how we send the report,what we send in report,how to know that where is error.quickly tell me the answer...please

1704


Tell me how would you test your own element locator?

526


Name the frameworks that are used in software automation testing?

520


How to integrate Rational functional Tester with Rational Quality manager. Can anyone provide the details steps giving explaination with examples.

1582


Tell me how a text written in a text field could be cleared?

507






How to select an automation tool best matched for your project?

496


Do you know what is functional testing?

559


Simplify the term defect severity.

490


Elaborate the scripting standard while executing testing

503


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

1735


What are Keyword and Data driven frameworks in Selenium RC

2804


I am new to jmeter and i am working on .net application.I am recording the requests and pop up images data are not recording.can some one suggest an idea regarding this

1569


Hi, I wanted to go with TestingDomain-Automation. Regarding this I need to take training on any one tool either WinRunner or LoadRunner. Which is better to get job,having future and takes lesstime with easier***. pls mention one tool name. Basically iam manual test engineer on unix- platform.

1501


In Selenium how a test suit is run and report is generated.

1551


Can you explain me what is object repository?

543