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

Write a query to find the number of employees who got more
that 20,000/- and 50,000/- sal

Write a query to find the number of sudents in each course

Question Posted / uday kumar_anem

Answers were Sorted based on User's Feedback



Write a query to find the number of employees who got more that 20,000/- and 50,000/- sal Write..

Answer / uday kumar_anem

1. select count(*)
from employee
where sal>=20000 and sal<=50000

2. select count(*)
from student
group by course

Is This Answer Correct ?    11 Yes 0 No

Write a query to find the number of employees who got more that 20,000/- and 50,000/- sal Write..

Answer / krishna

here they want number of employees not empno.
select count(empid),sal from emp where sal between 20000
and 50000;

Is This Answer Correct ?    3 Yes 1 No

Write a query to find the number of employees who got more that 20,000/- and 50,000/- sal Write..

Answer / vishal

oh sorry i missed it..

thx for correcting me :-)

Is This Answer Correct ?    0 Yes 0 No

Write a query to find the number of employees who got more that 20,000/- and 50,000/- sal Write..

Answer / vishal

assuming emp-id and sal tobe the fields in the
table "Employee" followng query can be used

Select emp-id, sal from Employee where sal between "20000"
and "50000"
OR
you have to run two different queries to extract records as
selecting records above 20,000 would cover the second part
too

2. select count (stud_id) from Student where
course_name="Testing"

hope they would help

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Testing AllOther Interview Questions

What test plans consists of?

0 Answers  

what is SEI?

3 Answers   Accenture,

What is cause-and-effect (fishbone) diagram?

0 Answers  

Is there any working in siebel testing if so plz discuss some scenarios in siebel testing as iam preparing 4r the intrv it may be very useful to me...My mail Id :testing_amar@yahoo.com... I wud appreciate the guys and guls whoever helpme..Plz get back to my Id and gv sm tips... Cheers, Amar.gp

0 Answers  

Most of my QA team members work offsite. So collaboration between the team members is an issue that has been affecting our work badly. Does anyone have a solution for this?

1 Answers  




Which table achieves data from landing table?

3 Answers   CTS,

What is test management review and why it is important?

0 Answers  

To test a function, what has to write a programmer, which calls the function to be tested and pass test data.

0 Answers  

If anyone is having ISTQB certification study materials,please send to gul.e.raina@gmail.com

0 Answers  

What is the difference between uat (user acceptance testing) and system testing?

0 Answers  

Do you know what the mean of cmm and tmm?

0 Answers  

How many triangles are there in the following figure?

1 Answers   EA Electronic Arts, Wipro,

For more Testing AllOther Interview Questions Click Here
Categories