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 Test management fundamental?

1780


Zenq interview questions for manual testing

1415


can any one post the format of tracebility martrix Plz...... Maid Id: sandhya.shyamala@yahoo.com

1782


Work flow in testing in your company?

1356


hi this is chik here iam showing my current project ERP and am prepair in hr model please tell me details about it and what all function test in hr model and give me some test caserelated to this module.Please tell me am faceing lots of problem in interview am not able to explain in interview please help me out my id is chiku_69@yahoo.in

1535






I know functional test cases are derived from frs and system design specs. But are test cases for performance, database, boundary, relational integrity and other types of tests other than functional tests created from frs and system design specs as well? When are these test cases created? Are they in the same test plans alongside functional test cases or is their a different test plan that includes these test cases?

1696


Any one please can u tell me what is composer? An interviewer asked me do u have experience in Composer? its urgent.

1648


how do u manage scripts in winrunner when you application is changing frequently?

1491


what is a horizontal and vertical matrix explain with examples

2126


value momentum

1286


How can you do the usability testing?

725


WHAT IS OBJECT REPOSITORY? AND IT TYPES? HOW MANY TYPES OF ACTIONS ARE THERE IN QTP? CAN WE ADD NEW OBJECTS AND PROPERTIES INTO SHARED OBJECT REPOSITORY?

1462


How do you go about testing a project?

1541


how mapp the defect id in quality center?

1697


hi experts, i was asked to write down the requirement description,test scenario, and test cases for gmail login and send email and then to check the email was sent in the sent mails.the format given to me was like this: Req ID, Req description, Test Scenario, Test cases....Can anybody please help me out with this..

1586