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

select max(salary) as '2nd Highest Salary'
from Employee a
where 2<=(select count(*) from Currencies b where a.salary
<= b.salary);

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me what is the testng.xml file used for?

1125


Where will you maintain information like url, login, password?

1969


what is the difference between keyword driven frame work and data driven frame work.

2386


What type of scenarios can be automated?

1032


Tell us how to select a value in a dropdown?

1058


What is javascriptexecutor and in which cases javascriptexecutor will help in selenium automation?

1064


Write a short compiled module which selects random numbers. and what function is used to call your customized compiled module?

1017


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

1055


What kind of tests would you automate?

1068


What is tree view in automation testing?

1027


What are the various kinds of frameworks that can be used in software automation testing?

1019


How to select an automation tool best matched for your project?

1066


What are the pre-requisites to start automation testing?

1026


Do you know what is a xpath?

1065


Can we find all links on a web page?

986