Write a query to find second highest salary of an employee.
- 72 Answers
- 108660 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / bhaskar reddy thamma
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is build verification testing, bvt?
What are the 5 common software development problems solutions?
On what factors can you map the success of automation testing?
Can we find all links on a web page?
Explain what sikuli is?
What is junit? And what is junit annotation?
What is difference between selenium and QTP tools Which is best tool... Which is most used tool
Tell us how could you explain the main difference between webdriver and rc?
What type of scenarios can't be automated?
How to get the Background color of a Tab or Button in TestComplete Tool using VBScript? I have a validation that to verify whether a particular tab or button is highlighted or not. When the tab or button is highlighted the background color will be in Yellow color.If i get the background color then its easy for us to validate whether its highlighted or not. Can anybody help me on this?. Thanks in Advance.
Tell us the line of code webdriver driver = new firefoxdriver();.?
Explain me what is the difference between setspeed() and sleep() methods?
What is hybrid automation?
Tell me how can the user get a text of a web element?
Can anyone tell me the correct answer of below question....it is about Bugzilla tool. When bug will find out at the time of executio where it will save or what is the location of bug??
