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
How does load testing work for websites?
Have you completed the cps exam? Which one?
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).
IN AN APPLICATION HOW DO YOU IDENTIFY THE TASKS WHICH SHUD BE DONE MANUALLY AND WHICH SHUD BE AUTOMATED?
VSTET (Visual Studio Team Edition for Testers) which is in TFS (Team Foundation Server) - In what way is VSTET better than QTP?
Any one suggest me for Free ware (Opensource) Automation tool for regression testing.
How the object properties will be recognised by the tool If the functions/ statements are written manually?
Currently I do not have any automation in place in my project, but now I want to implement automation, what would be my steps?
When will you automate a test?
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.
Please explain what is the hybrid framework?
Tell us how can you create html test report from your test script?
Anyone aware of Test Runner (ETL Automation Testing tool) if so please help me with material in keerthi.smile14@gmail.com
Explain what is a relative xpath?
Stop automating the tests which run once?