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

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

4 Answers
9738 Views
CybAge, I also Faced
E-Mail Answers

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 certifications can a tester of less than 1 yr experience go for? which is the best certification and how many months of preparation is required?

1 Answers

Non-functional system testing includes

1 Answers

What is failure-directed testing?

0 Answers

What is Defect age?

9 Answers

What is a Test Plan and What it contains?

2 Answers Virtusa,

What were your testing responsibilities at your previous employer?

0 Answers

Explain test driver?

0 Answers

What r all the resources u need 4 the project u r currently in?

0 Answers

what is thee diff between functionality testing and blockbox testing?

4 Answers MBT,

i am fresher in manual testing.how to do database testing as a manual tester.suggest me some answers,so that i will have a clear idea adout database testing.

0 Answers

may i know the sites which r giving model question papers for istqb exam

2 Answers

give an example of unit test and integration test and system test and UAT test?

1 Answers Spring Computing Technologies, Trealth,

For more Testing AllOther Interview Questions Click Here