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 / varun b n

select * from emp where sal = (select Max(sal) from emp)

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

PLS SEND REAL TIMERS, WHAT IS SOA TESTING..IM TRYING 3+ YR.. I HAVE GOOD KNOWLEDGE ON MANUAL TESTING... NOW IM NEW TO LEARN "SOA TESTING" IS BEST OR NOT? BEFORE LEARNING SOA TESTING ANY SKILLS ARE REQUIRED..... AND NOW WHAT IS THE MARKET FOR SOA TESTING... AND IT IS BASED ON PROGRAMMING OR NOT?

2337


what is the general pattern of explanation of projects in interview, can u ans me plz.......... ex: online banking application

1594


Pls u can u r mail id to my personal mail id also if they dont want to give u r mail id n comman place

1540


plz tell me the difference b/w PB/MF based appl.with examples. Thanks

1531


Unix question: 1)command to print a list of files containing a particular word. 2) what does a .profile mean. 3) what is a file server? 4) Command to move towards left in vi editor explain grep and find commands using example.

2077






What is a test severity and test priority? difference between them with suitable examples?

1311


what are the common errors while doing integration,system,functional,regression,user acceptance testing? can anybody please let me know the answers it is too urgent???

1583


What is Test Design ?( Urgent) and Test Design for Printer?

1564


Can you explain equivalence partitioning?

598


What is grey box testing?

733


any one please send me any test case examples with tabular columns in manual testing

1753


how to test ecg machine?

1377


Define Stability, Scalability and reliability with example ?

2780


What are the cases why parameterization is necessary when load testing the Web server and the database server?

1598


what is traceability matrix and its usefulness

3427