here they want number of employees not empno. select count(empid),sal from

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 / krishna

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

Please Help Members By Posting Answers For Below Questions

Explain static analysis?

601

What is the main objective when reviewing a software deliverable?

813

What is version description document (vdd)?

607

What is a 'walkthrough' in Software Testing?

681

What is the major problems you resolved during your testing process?

1769

Is it true that we can do system testing at any stage?

547

Functional testing?

558

how to use bugzilla plz tell me details processs

1578

how cam www sites be tested

1512

Tell me about the risk-based testing.

608

What is path testing?

695

Describe to the basic elements you put in a defect report?

606

What is recovery/error testing?

601

Compare between FCOE and iSCSI

1449

What is oo system testing?

585