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

How can you eliminate the product risk in your project?

0 Answers  

---

What are cookies? Tell me the advantage and disadvantage of cookies?

2 Answers   TCS,

---

Tell me about something you did ? or failed to do ? that you now feel a little ashamed of.

2 Answers  

---

WHAT ARE THE VARIOUS RISKS INVOLVE IN TESTING?

0 Answers   NIIT,

---

What parameters to consider for Performance Testing?

6 Answers   Virtusa,

---

Testplan & Tesdata a.)Testers workbench b.)Testing Strategy c.)Testing Policy d.)Testing Measurements

1 Answers   Amdocs,

---

What is Multipath I/O?s

0 Answers  

---

There are 3 employees(say 2 colleagues and u not from same dept) in an organisation they used to discuss any thing except their salaries and one day stranger came and asked u to tell the average salary!plz give me the solution.

6 Answers   Oracle,

---

What is linked Servers in SQL Server

1 Answers   CybAge,

---

What is software failure?

0 Answers  

---

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,

---

What is the role of moderator in the review process?

0 Answers  

---