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 2 tier and 3 tier application? Pls illustrate it with appropriate example.

2178


HI Any one can guide me What is database testing ? And How will do it . Please refer me any site or document to know more abt data base testing.

2235


Explain test bed?

1041


Hi can anyone pls let me know, how many test case can be written to this C question (Unit testing) *funame (Int x, Long b) { x=b; x < 5 } Note: - Return type is boolean - Input type is unsigned char

2032


Which technique can be used to achieve input and output coverage? It can be applied to human input, input via interfaces to a system, or interface parameters in integration testing.

1517


Best institute for protocol testing in Hyderabad ? How will be the market for protocol testing ?

2241


What do you mean by automated testing?

1178


What is operational requirements?

1121


What is criticality?

1075


Explain basis path testing?

1167


What is test first design?

1281


What is test executive?

1167


Explain exit criteria?

1093


Could anyone let me know what exactly is telecom testing & how is it done? And also how is mainframe testing done?

2001


What is the difference between model based testing and state transition testing? Or are they the same?

2658