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 we have done after display the result in openSTA result pane.in the sense that how we send the report,what we send in report,how to know that where is error.quickly tell me the answer...please

2206


Is automation testing a complete replacement for manual software testing?

1128


When you will not automate testing?

1058


Could any one share scripts... where we can Parameterize radio buttons and Check boxes in Rational Robot.

2083


What are the differences between open source tools, vendor tools, and in-house tools?

1083


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

979


I am new to jmeter and i am working on .net application.I am recording the requests and pop up images data are not recording.can some one suggest an idea regarding this

2003


Tell me what type of scenarios can be automated?

931


i need test cases for defect maganement tools

2058


2. How you will collect a module from the version?

2424


Can we prioritize tests in Junit. What is the sequence of execution in Junit?

1992


what is critical test case ? please give an example .

1848


Manually in a page 10 check boxes is there.so 5 check box "on" and 5 check box "off" so using descriptive program how to know how many "on" and how many "off" plz help me this question answer?

2395


Tell us can we find all links on a web page?

994


Tell us what is the difference between single slash (/) and a double slash ( //) in xpath?

1218