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
9729 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 is upward compression?

0 Answers

When is rtm (requirement traceability matrix) prepared?

0 Answers

What is negative and positive testing?

0 Answers

what happens in a web application when you enter all the data and click on submit button suddenly the connection goes off? where the data will go ?

1 Answers

What is the term for decomposing a software program so that latent design information can be extracted? 1. Reengineering 2. Regression 3. Restructuring 4. Reusability 5. Reverse engineering

0 Answers

Which of the following is least like the others? a) Cube b) Sphere c) Pyramid d) Circle

3 Answers EA Electronic Arts,

what would be the test plan for agile testing??

1 Answers

Explain cyclomatic complexity?

0 Answers

Hi..I want testing in worker compensation claims.. if anyone have real exp..can you explain it for me.. thanks

0 Answers

Difference between Verification and validation.

3 Answers Cap Gemini,

What is system?

0 Answers

What are the technical reviews?

1 Answers TCS,

For more Testing AllOther Interview Questions Click Here