Write a query to find second highest salary of an employee.
Answer Posted / rk
select sal from
(select rank() OVER (order by sal desc) sno ,sal from emp)
y
where sno= n
here
y : is the alias name for (select rank() OVER (order by sal
desc) sno ,sal from emp)
n : is the number ie if u want second highest sal then 'n'
value will be 2. for third highest n= 3...
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
hello frnds this pooja i hav started working on selenium with java ecllipse frnds could u tell me how to handle popup windows and security alerts i m jst trying and couldn't do anything plz help
Give some examples for test management tools?
On what basis you can map the success of automation testing?
In what condition we cannot use automation testing for agile method ?
What is hybrid automation?
Tell me what type of scenarios can be automated?
Tell me an example of the languages supported by webdriver?
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.
5. What are the tests you are conducting through winrunner?
Is there any freeware tool for automation testing of mobile applications for BlackBerry and iPhone platforms ?
In Selenium how a test suit is run and report is generated.
whether flash selenium supports to test Gaming application? like follows: identifying the images, dynamic animations, Dynamic value changes field and win conditions etcc..,
What is the process of Automation Testing?
What is testng and why is it better than junit?
what r the diffence between QTP 8.2 & QTP9.0?