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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

I am working with asp.net 2005 and Crystal report 10. I have an image field on my dataset to show on Crystal report.And the image is shows dynamically from database in image field of CR. The image field is showing well on my Crystal report on its first page with all other data but when i click to open second page of CR,it does not show any data on that.I found that this is because of adding the image field on crystal report. Because when i remove the image field from the CR then it will run both the pages of CR. I am using the Page Load event to bind CR data with Database. And i have already check with the Init event to bind CR , but it still not shows the data on second page when i use image field on that. Please give solution for that.....

1873


What is private constructor? And it's use?

1116


What is password attribute of the textbox control of .net mobile? : Microsoft dot net mobile

931


Explain difference between state server and sqlserver? : .NET Architecture

940


Explain dotnet framework ?

1031


Explain some of the disadvantages due to microsoft.net?

977


what are login controls?

1881


any one can explain about projectarchitecture and project approach briefly

2499


Session State and can i store desirialized object in state server, if yes how and if not why.

1780


Explain what does the term "green architecture" mean? : Dot net architecture

953


Explain .net mobile automatic paging? : Microsoft dot net mobile

919


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

963


What is the .net class that allows the retrieval of a data element using a unique key?

1008


what is the method while we are using adapter and dataset ?

1854


What is cache coherency and how is it eliminated? : Dot net architecture

943