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

Differnce between managed code and unmanaged code ?

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

Can you give an example of when it would be appropriate to use a web service as opposed to a non-serviced .NET component

What is Opf3

How resource files are used in .net?

How does an appdomain get created?

What is .net mobile input validation. Explain with an example? : Microsoft dot net mobile

what is meant by language interoperability and language integration?

There are so many languages are already existing for developing application.Then what is the need of .net.

11. diff b/w Dll and Exe

What is difference between .net and visual studio?

what is just in time compilation?

For more Dot Net AllOther Interview Questions Click Here