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

Explain how to test documents in a project that span across the software development lifecycle?

0 Answers

what is trigger? What is stored procedures? What is a cursor?

2 Answers SumTotal,

Hi, Can nybody tel me the how much a Manual tester should know about Database and its connections with the web application?

3 Answers

why we split testing into distinct stages?

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 is Entry and Exit criteria for a Test Plan?

4 Answers TCS, Virtusa,

What are the main key components in Web applications and client and Server applications? (differences)

1 Answers TCS,

Explain end-to-end testing?

0 Answers

I am planning to write a ISTQB Certification exam , i don't know about EXAM fee structures , please tell me the fee structure ? mail id: karthitkd.123@gmail.com

0 Answers Accenture,

Hi, I am writing ISTQB foudation exam on 9 June 2010. Anyone please send me pdf of the book "Sample Exam Questions: ISTQB Certified Tester Foundation Level (Paperback)by John A. Estrella " to hsdantot@yahoo.com Thanks Sree

0 Answers

What is a test harness?

0 Answers

What is random/monkey testing? When is it used?

0 Answers

For more Testing AllOther Interview Questions Click Here