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

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
9519 Views
CybAge, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List the comparison between FC and FCOE?

2284

What is a shrink wrapped product?

1943

What is latent defect?

948

If anyone is having ISTQB certification study materials,please send to gul.e.raina@gmail.com

2057

How will you recognise if a case is a 'test case'?

1106

What is bottom-up testing?

1049

hey guys ... since i have just started my career i need to know whether testing has a good career or not .. ?

1869

what is the difference between the normal testing and embedded testing?

1140

Explain dynamic testing?

968

Which one of the following activities is the most efficient and most cost effective at identifying defects? 1. Prototyping 2. Unit test 3. Beta test 4. Design/code inspection 5. Risk analysis

2038

What is api (application programming interface)?

1051

Explain quality control?

994

What is code review?

1053

Hello, I would like to know which all versions of Testing tools (load runner, winrunner, qtp, test director) are no longer used and which versions of these which are being used?

2549

What does the mclabe cyclomatic complexity of a program determine?

1065