Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What criteria do you consider for automating a test?

1011


Tell me how can the user get a text of a web element?

952


Which protocol cam be used to makw jdbc connection woth loadrunner

1007


Is automation testing a black box testing or white-box testing?

969


How can we make one test method dependent on other using testng?

990


Can you do without a framework?

1056


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

2114


Which package can be imported while working with webdriver?

1429


How automation process is carried out?

1026


What are the points that are covered while planning phase of automation ?

1162


What is a framework for automation testing?

1075


What is junit annotation?

1030


Tell us how can you find if an element is displayed on the screen?

981


What is build verification testing, bvt?

1116


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.

5261