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

Its real simple. Suppose your employees are in a table
called by the same name, and the salaries in a column named
salaries). Lets See te case in which we want the 3 greatest
salaries. Then you Query:

SELECT employees.salary
FROM employees
ORDER BY employees.salary desc
LIMIT 3;

If you want the biggest 5 salaries, you put LIMIT 5, and so on….

Is This Answer Correct ?    3 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does load testing work for websites?

1196


Have you completed the cps exam? Which one?

1017


in keyword driven frame work..where Driver Script is locate? is there any inbuilt script for driver script?who writes the driver script?how to call it any body can tell me with an example...like(yahoo login,inbox, logout).

2125


IN AN APPLICATION HOW DO YOU IDENTIFY THE TASKS WHICH SHUD BE DONE MANUALLY AND WHICH SHUD BE AUTOMATED?

2357


VSTET (Visual Studio Team Edition for Testers) which is in TFS (Team Foundation Server) - In what way is VSTET better than QTP?

3753


Any one suggest me for Free ware (Opensource) Automation tool for regression testing.

2052


How the object properties will be recognised by the tool If the functions/ statements are written manually?

2268


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

1169


When will you automate a test?

1111


hi to all, if we open a browser(for ex. yahoomail.com) using navigate command. the cursor by default focussing on the 'yahoo id' html edit box. how to get the label(ie.,yahoo id) of that html edit box using descriptive program. here we should not use identify tool to get the property,thtml editbox method. by tracing the cursor position we have to get the label name. is it possible? please let me know.

2281


Please explain what is the hybrid framework?

1124


Tell us how can you create html test report from your test script?

1060


Anyone aware of Test Runner (ETL Automation Testing tool) if so please help me with material in keerthi.smile14@gmail.com

1628


Explain what is a relative xpath?

1127


Stop automating the tests which run once?

1104