1. Categories >> Software >> Testing >> Manual Testing
  2. Suggest New Category

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).

Question Posted / swathi samyuktha

Answers were Sorted based on User's Feedback



An employee table, with the columns id, name, sal and dob.Query to select emp names of all highest ..

Answer / sujan thota

select name from emp where sal=(select max(sal) from emp)

Is This Answer Correct ?    6 Yes 0 No

An employee table, with the columns id, name, sal and dob.Query to select emp names of all highest ..

Answer / varun b n

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

Is This Answer Correct ?    6 Yes 2 No

An employee table, with the columns id, name, sal and dob.Query to select emp names of all highest ..

Answer / n. pavankumar

select * from emp where sal in (select max(sal) from emp)

Is This Answer Correct ?    2 Yes 2 No

An employee table, with the columns id, name, sal and dob.Query to select emp names of all highest ..

Answer / naveen kamatam

select ename, salary from emp e
where 4 > (select count(distinct salary)from emp where
Salary > e.salary)

it will fetch top 4 high salary records

Is This Answer Correct ?    1 Yes 2 No

An employee table, with the columns id, name, sal and dob.Query to select emp names of all highest ..

Answer / n@n!

emp table= emp;
column id =column_id;
name = name;
sal= sal;
dob= dob;


select top 1 name,sal,column_id,dob from emp order by sal
desc

while u run this query only one row was effected which
shows employee taken highest salary along with details like
column id,dob,name,sal.

if u want 5 employees list then replace top 1 by top 5



plz let me know if it was wrong (along with ur
query)...................

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Manual Testing Interview Questions

How do you estimate staff requirements?

1 Answers  

What are the Level of Severity

11 Answers   Atlantic Scientific, Deloitte,

What is test data

3 Answers  

What is difference between QTP 9.2 and QTP 8.0 ?

1 Answers   ACS,

I need a Test case templetes for Yahoo Mail ID

1 Answers  




what is differance between web applicatins and web based applications?

0 Answers   CA,

What is the difference between static and dynamic

1 Answers  

in case of web application what kind of areas we r tested and one more in case of database testing what we are testing tell me in brief.

1 Answers   HCL,

what is the difference between BVA&ECP?

3 Answers   Infinite Computer Solutions, TCS,

How you perform sytemtesting in organization, i am not asking definiton approach for system testing

3 Answers   CTS,

About Hierarchy level in your company.

0 Answers  

what is meant by Priority and Severity?

2 Answers   Crea,

For more Manual Testing Interview Questions Click Here
Categories