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

Can you explain server controls in atlas?

0 Answers  


Explain the Lapsed Listener problem in .net

0 Answers   HCL,


how to set the startup position of the form?

0 Answers   Six Sigma,


What are the five stages in a dlx pipeline? : Dot net architecture

0 Answers  


what are constructors and destructors?

0 Answers   Six Sigma,


Why only boxed types can be unboxed?

0 Answers  


Define the mesi? : Dot net architecture

0 Answers  


Explain in-proc,out-proc and sql server.

4 Answers   G7 CR Technologies, Ness Technologies,


How do I stop a thread?

0 Answers  


how we can fire event in databound column in datagrid without using button?

0 Answers   Tech Mahindra,


What does the "EnableViewState" property do? Why would I want it on or off?

2 Answers  


What is Object Caching in Visual Studio 2010?

0 Answers   Arigo Infotech,


Categories