how to get top two salaries from employee tables
Answer Posted / maruti
select max(sal)
from emp
where sal < (select max(sal) from emp);
with this query u ll get second largest sal of that table
if u want to know max (sal) then it ll be...
select Max(sal)
from emp;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Hi, i am looking job in perfomance testing using Loadrunner can any body help me a project in any domine plz(Usah) chs_29@rediffmail.com
What do you understand by usability testing?
In usability testing we check spelling, content, look and feel, color combination, link or menu navigation? please let me know more about usability testing.
What is bug, deffect, issue, error?
How could you present test strategy for the product testing?
How to explain the Insurance project in the interview?
Please explain how to elaborate on the types of system/functionality for testing Payments, Statements, & Transactions features in a bank.....like what do we test in these,in detail? It's urgent, please reply...thanks in advance.
what are the tests u did in entire project? when it did in the project? (means at the release build to end of project) plz explain clearly
Who are all involved in an inspection meeting?
What is configuration management in software testing ?
send the senario template
You have a testing team of 10 members, and now you have to reduce it by 5 member and you dont want to increase risk in your product, you are try to cover all functionality to test. What test Strategy you follow.
What do you do (with the project tasks) when the schedule fails?
Why you are selected software testing as career ?
what are the prerequisite conditins to test clientserver and web applications