Answer / uday kumar_anem

1. select count(*)
from employee
where sal>=20000 and sal<=50000

2. select count(*)
from student
group by course

Answer / krishna

here they want number of employees not empno.
select count(empid),sal from emp where sal between 20000
and 50000;

Answer / vishal

oh sorry i missed it..

thx for correcting me :-)

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

What is JBOD?

0 Answers  

---

U may undergone many projects. Do all the projects match up with customer's expectations?

2 Answers  

---

What is a 'walkthrough' in Software Testing?

0 Answers   MCN Solutions,

---

Testing that checks that a modification applied during maintenance has NOT affected the code corresponding to those functions of the system that should be unaffected by the modification is called which one of the following? 1. Acceptance testing 2. Unit testing 3. Regression testing 4. Validation testing 5. System testing

5 Answers  

---

What is system test?

0 Answers  

---

What is the major risk or challenge faced by you as QA analyst other than clash with the developer regarding the defect log.

1 Answers  

---

What is the formal technical review?

1 Answers   Accenture,

---

What is the difference between Code Release and Code Build?

1 Answers   CTS, L&T,

---

Explain ad hoc testing?

0 Answers  

---

What is test script?

0 Answers  

---

When is a test considered to be successful?

0 Answers  

---

I am having 1.5 years of exp. in Manual testing.What I have to do now? Should I do ISTQB Certification or Perl/Shell Scripting Languages? OR Anything else.Please Guide me properly.

0 Answers  

---