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 / 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
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the difference between negative and positive testing?
What is sei - software engineering institute?
What is dynamic analysis?
What is code review?
Explain test plan?
hey, i recently attended 2 interviews and they asked whether I used qamonitor of softsmith. any help on what it does?
hi friends ,, i will give a small advice for all of ,, pls send genune answering don,t send half knowladge answers pls pls pls ....... i faced so many problms in interview pannels so pls pls
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?
Functional testing?
What is testing type and what are the commonly used testing type?
A number of critical bugs are fixed in software. All the bugs are in one module, related to reports. The test manager decides to do regression testing only on the reports module.
How will you log a Defect when you are in the process of executing a test case?
What is a 'walkthrough' in Software Testing?
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
What is boundary value?