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

How does .net remoting work?

609


What is Object Caching in Visual Studio 2010?

595


What is the purpose of hard disk? : Dot net architecture

485


What is .net viewstate?

492


What is a managed code? : Dot net architecture

547






What is the purpose of Treeview control?

549


What is difference between Desktop, Client Server & Web based applications?

532


What is WPF and WCF?

573


how to change the application name?

1498


how to create applications by using Visual Studio 2012?

571


Explain about validation?

596


What are the main Tools to develop .Net Application?

534


What is .net mobile lists. : Microsoft dot net mobile

474


what are the fundamental and common properties of .net controls?

1598


What are different types that a variable can be defined and their scopes ?

594