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
- 8250 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
In which phase should testing begin – requirements, planning, design, or coding?
What are the main constrains of SCSI in storage networking?
Please some one answer these Q's 1.Modules in Pension Domains ? 2.What Should we Test on Pension Domain.? Thanks in Advance Stewie
What are the ways of functional testing? Can you give me an example of how to perform Functional testing on a Login Page for example.
What is assertion testing?
Explain inputs?
Explain monkey testing?
what is the meaning of Field Level Validation & Form Level Validation??
What is the difference between uat (user acceptance testing) and system testing?
hai, i completed my B.Tech.i planning to join in testing tools.can anybody suggest me good institute.I heard about Nageshwara Rao sir institute for testing tools.Now which one is good so i can get job in testing tools. please help me.....where to join in hyd.
If anyone is having ISTQB certification study materials,please send to gul.e.raina@gmail.com
What is FCOE?
What is policy?
What is the testing process you follow in your organization?
What is the information that should be covered in test plan?
