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

--SUPPOSE PRICE IS SALARY

SELECT
TOYNAME,TOYPRICE FROM TOY
WHERE TOYPRICE<(SELECT MAX(TOYPRICE) FROM TOY)ORDER BY
TOYPRICE DESC LIMIT 1;

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can i count the no of edit field in a page and fill the multiple edit field

2533


What is test automation?

2222


What kind of tests would you automate?

1070


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

2472


Explain what is a relative xpath?

1136


What is tsl?

1100


Give some examples for defect management tools?

1111


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

1127


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.

2310


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

1179


Is automation testing in agile methodology useful or not?

1042


Tell us what is the difference between @factory and @dataprovider annotation?

1169


What is an automated test script?

1284


Do you know what is the purpose of deselectall() method?

1080


What are the steps to perform Load and Stress testing on a Website? What resources do I need to do this? Please advise. Thanks in advance.

2051