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

select * from employee where salary < (select max(salary)
from employee)
(i have written as sub query)
is this right

Is This Answer Correct ?    5 Yes 31 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the primary features of good automation tool ?

1034


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.

1835


How do you identify the test cases which are suitable for automation?

1044


Tell us what methods of robot class do you know?

970


How automation process is carried out?

1026


Can we find all links on a web page?

935


Please explain what is the hybrid framework?

1071


I am fresher and i have completed my software testing course and i don't have real time experience,can anybody help me regarding financial domain projects,main testcases in that domain.

2240


What are different coverages in function testing?

1139


Explain me what is the difference between setspeed() and sleep() methods?

1071


What are Keyword and Data driven frameworks in Selenium RC

3327


What is the difference between continue and next sentence?

1109


Tell us what is the difference between getwindowhandles() and getwindowhandle()?

1030


What is testng and why is it better than junit?

1050


Do you know what is a xpath?

1007