Write a query Where,Groupby,having clauses?

Question Posted / suresh mediboyina

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

More Dot Net AllOther Interview Questions

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

Can you explain atlasuiglitz library?

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

What is msil, and why should my developers need an appreciation of it if at all?

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

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

State and explain about microsoft.net?

How do you handle this COM components developed in other programming languages in .NET?

What is the use of web.config?

what is just in time compilation?

What is the purpose of cache? How is it used? : Dot net architecture

What's the difference between an application and a program?

For more Dot Net AllOther Interview Questions Click Here