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

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

Please Help Members By Posting Answers For Below Questions

Explain performance testing?

1058

Explain incremental integration testing?

1121

What the difference between pilot and beta testing is?

1039

What are enter & exit criterias of a test paln?

1260

Explain what test plan is?

1113

What is crash?

1089

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

1100

What are the categories of defects?

1065

how i find swing lenth of probe ?

2178

What is the objective of regression testing?

1069

What is the difference between testing techniques and testing tools?

1154

Mention what bottom-up testing is?

1013

What is the main objective when reviewing a software deliverable?

1382

What is a test closure?

1080

Explain virtual memory?

1028