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

Define dma? : Dot net architecture

546


Explain hard disk and what is its purpose? : Dot net architecture

512


How to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile

514


Explain cache memory? : Dot net architecture

535


What is the difference between primary & secondary storage device? : Dot net architecture

523






What is IL code, CLR, CTS, GAC & GC?

592


How to improve the cache performance? : Dot net architecture

529


Explain hard disk and what is its purpose? : .NET Architecture

529


What is the difference between absolute expiration and sliding-time expiration?

531


How do I write to the application configuration file at runtime?

522


Difference between type constructor and instance constructor?

549


What is a clickonce application?

511


Explain Intermediate Language?

600


How to upload in video,mp4,in .net 4.5 ..?

552


Tell me .net mobile emulators? : Microsoft dot net mobile

551