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

What is the difference between negative and positive testing?

1124


What is sei - software engineering institute?

1024


What is dynamic analysis?

1096


What is code review?

1136


Explain test plan?

1087


hey, i recently attended 2 interviews and they asked whether I used qamonitor of softsmith. any help on what it does?

2139


hi friends ,, i will give a small advice for all of ,, pls send genune answering don,t send half knowladge answers pls pls pls ....... i faced so many problms in interview pannels so pls pls

1918


Hello, I would like to know which all versions of Testing tools (load runner, winrunner, qtp, test director) are no longer used and which versions of these which are being used?

2592


Functional testing?

1021


What is testing type and what are the commonly used testing type?

999


A number of critical bugs are fixed in software. All the bugs are in one module, related to reports. The test manager decides to do regression testing only on the reports module.

1385


How will you log a Defect when you are in the process of executing a test case?

2228


What is a 'walkthrough' in Software Testing?

1209


IF i have two columns in Database , While using Database output value ,allthe values in the two column are set as a single row in the QTP datatable, can u suggest me a idea so that QTP Runtime datatable displays the values as it is in the database

2012


What is boundary value?

1062