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

integration test cases for mouse and keyboard

3213


How will you do beta testing?

629


write test case for linked in sign up page ?

1891


What is state transition?

659


Explain the sub-genres of performance testing?

685






Can any one explain me about hybrid integration testing? and what is interface in integration testing? thanks in advance...... regards, MurthySharma.Manchella

1802


why testcases are written and what is the importance?

1099


what are the risks and contingencies u had in ur project?

2044


1.Enlist the types of testing performed for any window in sequence? 2.Use of edit_get_list function 3.Accuracy & Precision

1689


how to indentify memory leakages after the build

1633


Can you explain equivalence partitioning?

586


How to do security implementation for any URL??

1422


What is checkpoint? How can you handle the checkpoints?

1992


What is your Approach when you find 10 Sev-1 bugs in 50 test cases?

2066


Hi,Please can any one tell me about SAP Testing concepts.

1539