Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 130585 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
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
What are the various kinds of frameworks that can be used in software automation testing?
How many test cases have you automated per day?
I want to learn the data base testing, how can I start my psactice? I already reading the books of basic for data base? If any other books that make my study simple please suggest.
In Selenium how a test suit is run and report is generated.
What is the difference between continue and next sentence?
Can you list some other automation testing tools that you are familiar with?
Do you know when autoit is used?
Hello Friends, I am Looking for the Load runner-Performance testing institute in HYD. I see most of them in this site are suggesting for TS Technologies as best institute for PT load runner. We you pls suggest me, Does this institute offers good coaching on Weekend Sessions/Batches? Does it covers all the course contents in these session? Please help me on this guys..
How does load testing work for websites?
Explain some automation testing tools.
what is GDC
Tell me which web driver implementation is the fastest?
In what condition we cannot use automation testing for the agile method?
Do you know what is a data-driven framework?
What is tsl?
