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 / mitul deshmukh

Select Salary
from Employee emp
where
2 = Select Count(Salary) from Employee emp1
Where
emp.Salary >= em1.Salary))

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain some automation testing tools.

1047


Where to maintain information like login, password and url?

964


What is junit annotation?

1091


How do you choose which automation tool is best for your specific scenario?

1125


Do you know what is a xpath?

1065


Bug report formate in bugzilla

2137


Explain what sikuli is?

1116


Give some examples of priority – severity defect levels.

1043


Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(

2247


Explain what is the difference between findelement () and findelements ()?

1071


22. Scenario: There are 1 to 100 numbers. Each number should be keep in the each column like from A column to Z column ie 1 to 26. From 27 to 52 should be in 2nd row in the excel sheet. This has to be continue till 100. How do you write Java program and what are various methods.

1887


What is junit? And what is junit annotation?

1154


how to use regular expression in Test Complete Functional tool

5501


Tell us what automation tools could be used for post-release validation with continuous integration?

1087


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

2054