how to get top two salaries from employee tables
- 12 Answers
- 21731 Views
- IBM, I also Faced
- E-Mail Answers
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
how many meeting in realtime environment? what are they?plz explain?
In Quality Center, If we can reuse a non reusable test script as template test, then what is the need of defining reusable test scripts? What additional functionality does Reusable test scripts add when compared to non reusable test scripts?
Define what is a critical bug.
What is the difference between action & script ?
In how many ways you perform batchtesting ?
What are the different servers and difference between them?
how is market for testing in banglore,chennai,pune,delhi?
what are the typical problems in web testing?
write test cases on wall
How can we test for drastic (severe) memory leakages?
Explain Test Plan with example? Explain following in the test plan with examples What is being tested? What are pass/fail criteria? When will each test occur? What Hardware & Software environment is required? What features must be tested? What features will not be tested? What are the responsibilities of individuals & organisation in the project?
Hi guys,I have 3+ years of exp in manual testing in a bangalore based MNC company.I Like to jump in chennai.So please if u know any jobs in chennai firms please let me know in my email-id. anbarasu2k@rediffmail.com. cheers, anbarasu.
How to find that tools work well with your existing system?
Hello. I am not here to answer your question. I jus found a job as software QA engr. And i am totally new to software testing. So can someone pls help me in the following scenario? there is this registration screen, and it contain: One textbox called Nickname which only accept alphanumerical One textbox called Contact which only accept numerical, One textbox called Email which can be filled with alphanumerical and symbol and One button called Register now becos there is so many textboxes, where i can filled with alphabet, number, symbol, "just space", leading zeros, leading space. there will be lots of combination. can someone pls help.. i will be appreciated if u can post the test case of the scenario i mentioned. Lots of Thanks
Relative to other technical groups in the company? Relative to your staff?
