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
How to track the requirement from bugzilla tools? As our project requirement are changing frequestly and all are tracked in bugzilla tool. How to manage all as all project having short term duration. Please reply back ASAP? Thanks in advanced?
Mention what the purpose behind doing end-to-end testing is?
'This life cycle model is driven by schedule and budget risks' this statement is best suited for.
What is the smallest unit of information transfer in FC?
What is api (application programming interface)?
Explain regression testing?
How will you define a critical bug?
What is fuzz testing and when it is used?
A type of functional testing, which investigates the functions relating to the detection of threats, such as virus from malicious outsiders?
What is a technical analyst?
Compare between FCOE and iSCSI
What is recovery/error testing?
can any one suggest best institute for SAP TESTING and scope in SAP TESTING
what r the 2 subdivisions of quality process and where does tesing fit?
What is coverage measurement?