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

What is back to back testing?

1586


what is the impact analysis?

2003


What is difference between Bug resolution meeting & Bug Review Committee? Who are participants?

2530


hai friends, I need clarifications for some doubts in testing terminology. 1.What is thread testing. 2.What is bucket testing and which automated tool is used to do this test. 3. ERP testin automation testing. 4.What is Data Warehousing testing? 5.What is Implementation testing? 6.What is Shake out testing? please let me have the clarifications in detail

1666


What does you mean by positive and negative testing & what is the difference between them. Can anyone explain with an example?

761






How to test an Scheduled event? For ex: in an investment banking application, the scheduler will create an equity anbd user has nothing to do but tester has to test if the instrument is created properly or not?

1791


What is frame level testing and how do we test it?

2055


Write the test cases for yahoo home page

1806


What r the features,u take care in prototype testing?

1861


How to find bug in photos and videos ??

1849


What is the quality process is following in your organization.

1841


Sentence "Working from onsite is effective" is growing in IT field. How do we bring that knowledge to offshore and do an effective job in Offshore?

1749


What is the purpose of test strategy?

792


What is validation in software testing?

795


send the senario template

1585