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 Where,Groupby,having clauses?

Answers were Sorted based on User's Feedback



Write a query Where,Groupby,having clauses?..

Answer / reddy

select userid from usertable where username like '%raj%'
group by userid having userid between 1 and 4

Is This Answer Correct ?    12 Yes 3 No

Write a query Where,Groupby,having clauses?..

Answer / subhrangshu

Select ASSOCIATED_PRODUCT , MAX(YEARS)
from Contract
where CONTRACT_STATUS LIKE 'Executed'
group by ASSOCIATED_PRODUCT
having MAX(MONTHS) > 6

Is This Answer Correct ?    4 Yes 3 No

Post New Answer

More Dot Net AllOther Interview Questions

what is stage management ? (ASP.NET)

5 Answers   Ness Technologies,


Can you explain control extenders?

0 Answers  


how to minimize,maximize and restore my form programmatically?

1 Answers   Interlac, Six Sigma,


what is web service?

1 Answers  


What is the difference between l1 and l2 cache? : Dot net architecture

0 Answers  


What are the types of memory management? : Dot net architecture

0 Answers  


what is polymorphism and advantage ?

0 Answers   TCS,


Explain .net mobile selectionlist control? : Microsoft dot net mobile

0 Answers  


Explain the race around condition? How can it be overcome? : Dot net architecture

0 Answers  


how to create applications by using Visual Studio 2012?

0 Answers   TryTechnicals Pvt Ltd,


Explain Singleton design pattern in .net

0 Answers   Infosys,


9. Oop-Class A has m1 metthode Class B has m1 metthode and C is the calss that inharits A class, A class inharits B class. If Object dim c as new A() c.m1(), Tell me which mettode of class will call

2 Answers   PCS,


Categories