Write a query to find second highest salary of an employee.
- 72 Answers
- 108898 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / rajeshraajan
SQL Server ( For 2nd max Salary )
---------------------------------
select Min(salary) from
( Select Top 2 salary from
( Select distint salary from Employee Order by
salary Desc ))
with this query we can find n th salary.
if am wrong plz correct me.
thx
| Is This Answer Correct ? | 53 Yes | 95 No |
Post New Answer View All Answers
What are the limitations of automating software testing?
Tell us how to login into any site if it's showing any authentication pop-up for username and password?
In what condition we cannot use automation testing for the agile method?
Hi All, Is there any free automation tool for windows application and it's easy to use? I usually take a lot of time to regression test my application when there is a new build on live environments (about same 10 environments) I wish I know a automation tool to regression test and ofcourse it's free, easy to use (maybe using C#) Could anybody can advise to me a tool like that? I very appreciate ^^
What are the types of framework used in software automation testing ?
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.
What is the scripting standard while performing automation testing?
Anyone aware of Test Runner (ETL Automation Testing tool) if so please help me with material in keerthi.smile14@gmail.com
How is Jmeter tool very useful in projects when it does not have features like online monitoring,WAN emulation,caching like other performance tools.
if i want to use different values in datatable with each iteration of for loop what would i do ??/
Tell us what automation tools could be used for post-release validation with continuous integration?
If I have given names to different DataTable columns and those column names are stored in a variable, then passing that variable to the datatable how can i Enter different values in those columns listed in that variable?? Please explain me with an example.I am not getting it.
how can i count the no of edit field in a page and fill the multiple edit field
Tell me how would you test your own element locator?
hi i would like to know is there any training institue for Calabash,robotium and ui automator in hyderabad...urgent
