Write a query to find second highest salary of an employee.
Answer Posted / barochia dharmesh
select Income from (
select Rank() over(order by Income desc) topRecord, Income
from (select distinct Income from tblName) tbl ) tbl2
where topRecord = 2
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What criteria do you consider for automating a test?
Tell me how can the user get a text of a web element?
Which protocol cam be used to makw jdbc connection woth loadrunner
Is automation testing a black box testing or white-box testing?
How can we make one test method dependent on other using testng?
Can you do without a framework?
hi every one this is ashok pls any one give answer me pls question is while testing with selenium after giving id user name and password , the inbox will be open , how to handle this one
Which package can be imported while working with webdriver?
How automation process is carried out?
What are the points that are covered while planning phase of automation ?
What is a framework for automation testing?
What is junit annotation?
Tell us how can you find if an element is displayed on the screen?
What is build verification testing, bvt?
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.