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 friends I am kranti completed my IT diploma in 2005 & after that complete my software testing course. Now I am working in small software form as software tester. I have 2 + year experience in manual testing. Now I wan to change company. Plz told me is there any effect that I can not have any degree although I have 2 + experience ?
Hi Can any one tell wht type of questions will be asked in project manager round...urgent plz...
what is the architecture of your current project?
How can you use technology to solve problem?
1. what exactly is heuristic checklist approach for unit testing ?
What is Windows Test Technologies? Where i will get all information of it.
What is the negative testing and example
functional testing and usability testing test cases for transfer funds...
What is regression testing? When to apply it?
What are the two main categories of software testing?
i need manual testing interview questions for 2+ experience plzz help me..
Have you ever completely tested any part of a product? How?
Can you explain process areas in cmmi?
1.what is the approach while writing test cases in your project. 2.tell some intresting scenareo in your project
What are the different ways to check a date field in a website?