Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

you are a SQA lead on a project that uses an agile development environment, The lead developer has been instructed to write and initially-failing automated test case, then produce minimum amount of code to pass the test and finally refactor the new code to acceptable standards. based on above, Which type of SQA-focused SDLA is being used?

1662


What the main advantages of statement coverage metric of software testing are?

976


Hi can anyone guide me regarding how the interview procedures will be in exterro Inc, Coimbatore

2069


What is a user friendly software?

899


Explain acceptance testing?

986


What is software fault?

1009


What is structural testing?

1115


What is benchmark?

915


Tell me about the risk-based testing.

997


What is integration testing in software testing?

1009


What is version description document (vdd)?

1015


What is upwardly compatible software?

992


What were your testing responsibilities at your previous employer?

986


What is difference between JBOD and RAID?

2090


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

1930