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
8236 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

write a querry .if 10 records in a table.i want only 1 record and 3 reocrd and 10 record. how to write a querry.

2 Answers HealthTech,

How will you hack someone's gmail or yahoo account.

0 Answers

There will be two security guards at hell and heaven. hell guy used to speak lie always and we can ask one and only one question to move into heaven(twist is we don't know who is hell or heaven gaurd).how can we move into heaven?

20 Answers Keystone, Oracle,

2, 6, 12, 20, 30, ___, 56

8 Answers EA Electronic Arts,

When is a test considered to be successful?

0 Answers

HOW DO YOU COMMUNICATE WITH THE DEVELOPER ON DEFECT?

1 Answers

What is meant by Protocol testing

2 Answers

What test plans consists of?

0 Answers

An input field takes the year of birth between 1900 and 2004 what the boundary values for testing this field are?