An employee table, with the columns id, name, sal and
dob.Query to select emp names of all highest salaries(there
are 4-5 people having the same salary which happens to be
the highest).

Answer Posted / sujan thota

select name from emp where sal=(select max(sal) from emp)

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

On what basis you are fixing up the time for project completion?

774


Write test cases on duster

4225


What is your daily process? I have 2+EXP IN MANUAL TESTING.PLEASE SUGGEST ME HOW i ANSWER

1808


What is an audit report? Whom is it done by?

1951


Functional and Integration test scenarios for actitime application

6363






What is meant my Firewall testing? how the testing is performed on it?

1778


what risks do u faced u r projest how do you solve

1629


Where we have to use perl scripting in Testing approach and its importance

1649


What does a manual tester need to become proficient with db testing?

687


What is stub?

683


what is the testing approach for windows Explorer(Not IE Explorer)

2241


What is Test methodology, Testing type , Testing approach, Testing technique & Testing methods. Explain with example.

1512


What about the test case if the field only takes a certain number of characters or a minimum number?

667


What do you plan to become after say 2-5yrs (Ex: QA Manager, Why?)

1654


What type of metrics would you use?

1730