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

What is checkpoint? How can you handle the checkpoints?

2002


what we have to read to gain knowledge in banking and financial domain(software testing) for 4+ experience

1741


what is e-tester?

2052


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

1664


What is mutation testing & when can it be done?

687






What type of testing you perform in organization while you do system testing, give clearly?

705


1.Acceptance testing involves procedures for identifying acceptance criteria for interim life cycle products and for accepting them.is that? 2.Acceptance testing occurs only at the end point of the development process; it should be an ongoing activity that test both interim and final products.is it?

1871


functional testing and usability testing test cases for transfer funds...

1260


Write a Test scenario for Outlook Search functionality.

2597


explain fish model in detail?

1739


Can test condition,testcase and testscript help u in performing the static testing

1613


What is the difference between three tier and two tier application?

672


Explain what is exhaustive testing?

811


Tell me agile process in your company

5664


What is your approach when requirements change continuously?

719