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 / shahnawaz

please check this one .
first rank the salary coloum and then find nth heigest
salary
use rank function


select * from
(select a.*, rank()over(order by salary desc) rn from
emp_shah a)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

pls tell me any open source test case managment tool ? its urgent.also tell me any autmation testing tool also for functional testing?

2282


Explain about basics of rational robot - ibm test automation tool?

1096


What is test driven development?

1101


Currently I do not have any automation in place in my project, but now I want to implement automation, what would be my steps?

1105


What is hybrid automation?

1023


How will you automate basic “login” functionality test cases for an application?

956


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??

1927


What is in-house tool?

1044


Tell us how do you get the width of the textbox?

970


Explain some automation testing tools.

987


Anyone have idea of jmeter.IF so pls contact to this mail id arun130887@hotmail.com

1979


Please explain what is a relative xpath?

1088


What are the steps involved in the automation process ?

1277


Tell me how could the web element attributes be inspected in order to use them in different locators?

1049


Explain me what is testng and why is it better than junit?

1075