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

Hi do any one has dumps for ISTQB or ISEB exams for august or september exam 2013. Pleae mail qazwsx2631981@yahoo.co.in

0 Answers ISTQB,

What is software fault?

0 Answers

What is the difference between Testing and Code review?

4 Answers

Hi, I attended an interview recently. I was asked the following question Assuming that I am Test Manager. There are 20 resources out of which 12 are manual testers, 5 automation testers and 3 performance testers. There are a bunch of projects to be tested in the organisation, the projects belong to various technologies, say 20% of projects in Java, 20% of projects in SAP, 30% of projects in .NET, 30% of projects in C# What is your approach as Test Manager in testing? Pls let me know your approach on this.

6 Answers CTS,

Explain validation?

0 Answers

What is the information that should be covered in test plan?

0 Answers

What is considered to be a good test?

0 Answers

What is the difference between model based testing and state transition testing? Or are they the same?

0 Answers

Explain configuration management?

0 Answers

Test cases Asignment 1. Write test cases for if your pendrive is not working 2. Write test cases for if optical mouse is not working 3. Write test cases for login id if its range is of 11 alphanumeric 4. Write test cases for if next button is working or not 5. Write test cases for,where bike max race is 120 km/h Mail me on mca.rachna21@gmail.com

1 Answers

What are the structure-based (white-box) testing techniques?

0 Answers

What is equivalence partitioning testing?

0 Answers

For more Testing AllOther Interview Questions Click Here