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
What about the test case if the field only takes a certain number of characters or a minimum number?
Difference between adhoc testing and error guessing?
What is test out put?
can anybody send the project you have tested with the clear descriptions,and recent bugs u found in that
whar are the contents in db testing test case template
Can you explain steps in function points?
Can you explain the elementary process?
What is decision table testing?
What is difference between web site testing, desktop application testing and wireless application testing? what is the difference in testing strategy to test them?
Hi , Please send me the interview questions which were asked in manual testing mainly the test cases asked to write in interview.
Risk Analysis a) 2 step, b)3 step, c) 4 step, d) 6 step
Can anyone please tell in detail about the Rally tool and how a tester is going to use it.
List the considerations in developing testing methodology
what is fusion testing and impact analysis???
what are the Cs in testing