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
How to capture Dos Promote data in text file? in that how to find particular String ( window )? in VB scrpting
What is mean by ARGO testing? Can you please explain anyone
Name some of the commonly used automation testing tools that are used for functional automation.
Tell us the line of code webdriver driver = new firefoxdriver();.?
What all different approaches can be used for designing an automation solution?
Tell me what is regression testing?
How did you use automating testing tools in your job?
How do select which automation testing tool is the best for you?
How to check if an element is visible on the page?
Which is the best place to learn Loadrunner performance testing in hyderabad ?
What is the different between GUI map and GUI map files?
Tell me what is the firefoxdriver, class or an interface? And which interface does it implement?
Explain me how to check if an element is visible on the page?
all clients are using at once if any problem raise?
What criteria do you consider for automating a test?