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
- 8229 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
What is ansi - american national standards institute?
What is parameter?
what is system testing?
What is validation and verification testing?
How can you eliminate the product risk in your project?
What is Functional, Non-Functional, and Regression used for (i.e. the purpose of each)?
Could anyone let me know what exactly is telecom testing & how is it done? And also how is mainframe testing done?
hello everybody, I have started learning testing tools and have familiarity with winrunner and general testing knowledge.Pl let me know what other stuff should i learn. I had 6 yrs of exp in GIS field and now i want to shift to testing tools. I left my job in 2001 now i want to enter into the market again. Could any of u help me how to approach the market. Any suggetions are very helpful to me. I am in US though. Thanks in advance
Hi can anyone guide me regarding how the interview procedures will be in exterro Inc, Coimbatore
what are the different types of questions in testing from related to projects, plz help me in quickly
Hi, Can any one please provide any links regarding the interview questions for Computer Systems Validation. I have got QA background and looking for a career in CSV in Pharmaceutical Companies. Thanks in advance...
I got an offer from TCS as a software engineer, But it says I will work for TCS BPO, Is there any difference in policies of TCS BPO and TCS-IT Services.How is the Working enviornment and appriasal procedure
Explain operational testing?
How do the companies expect the defect reporting to be communicated by the tester to the development team. Can the excel sheet template be used for defect reporting. If so what are the common fields that are to be included who assigns the priority and severity of the defect.
What are the two parameters which can be useful to know the quality of test execution?
