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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does anybody used Visio in QA.If so, can u please explain where and when u used visio diagrams

2598


In which order should tests be run?

615


Explain installation testing?

618


I need to learn everything I can about Function, Non-Functional and Regression Testing. What is the best online resource?

718


IF i have two columns in Database , While using Database output value ,allthe values in the two column are set as a single row in the QTP datatable, can u suggest me a idea so that QTP Runtime datatable displays the values as it is in the database

1515






I am planning to write a ISTQB Certification exam , i don't know about EXAM fee structures , please tell me the fee structure ? mail id: karthitkd.123@gmail.com

1547


what is the role of external testing companies?

1606


Can anyone provide the definitions for the following abbreviations? Thanx to anyone who could CIT CAP

1578


What is a test closure?

582


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

1628


Explain fault?

587


hi frens, i need ur help if nebody had worked or workin on online banking projects n online job portals ..frens cud u pls gimme the realtime examples for critical bugs, high severity n low priority bugs high severity n high priority bugs low severity n low priority bugs high severity n low priority bugs related to banking n job portal

1573


Why we use decision tables?

622


What is oo function testing?

600


What is the smallest unit of information transfer in FC?

1926