Select ASSOCIATED_PRODUCT , MAX(YEARS) from Contract where CONTRACT

Write a query Where,Groupby,having clauses?

Question Posted / subhrangshu

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

Please Help Members By Posting Answers For Below Questions

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

955

Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form.

956

Explain pipelining? : Dot net architecture

1005

Explain is development of a mobile web application with asp.net is very easy? : Microsoft dot net mobile

949

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

934

Explain different pipelining hazards? : Dot net architecture

986

Define a virtual memory? : Dot net architecture

919

Explain Singleton design pattern in .net

991

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

1002

Explain about clr?

1060

What is the cli? Is it the same as the clr?

954

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

1055

What is a clickonce application?

939

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

929

So what exactly is the configuration file for then?

966