Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126536 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / rajkumar mandala
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 ? | 7 Yes | 2 No |
Post New Answer View All Answers
how can i count the no of edit field in a page and fill the multiple edit field
When you will not automate testing?
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..
What are the pre-requisites to start automation testing?
How software testing is handled?
Any one suggest me for Free ware (Opensource) Automation tool for regression testing.
What is a critical bug in a testing field?
Tell us what you know about table-driven testing?
What are the advantages of test automation?
Tell us what methods of robot class do you know?
What are the limitations of automating software testing?
Elaborate the situation where automation testing can’t be used for agile methods?
how to import specifically 2nd column elements to runtime datatable in excel sheet if it contains 3 columns
Explain me which web driver implementation is the fastest?
How do you select which automation tool is best suited for you?
