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
- 4 Answers
- 8604 Views
- CybAge, I also Faced
- E-Mail Answers
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
A type of integration testing in which software elements, hardware elements, or both are combined all at once into a component or an overall system, rather than in stages.
What are the benefits of independent testing?
What is static analyzer?
what r the 2 subdivisions of quality process and where does tesing fit?
Which technique can be used to achieve input and output coverage? It can be applied to human input, input via interfaces to a system, or interface parameters in integration testing.
HOW TO PERFORM DATABASE TESTING
What advantages would using an iSCSI Storage Area Network (SAN) give to your organization over using Direct Attached Storage (DAS) or a Fibre Channel SAN?
How would you test the login feature of a web application?
What are the emerging trends in the testing and QA arena?
What r all the risks u r facing while doing a project?
Explain verification?
how to use bugzilla plz tell me details processs
What is the purpose of exit criteria?
What is utilization?
What is test incident report?
