Write a query Where,Groupby,having clauses?

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

Post New Answer

More Dot Net AllOther Interview Questions

Explain How to improve the cache performance? : Dot net architecture

0 Answers  


What is the problem with .net generics?

0 Answers  


How can a win service developed in .NET be installed or used in Win98?

1 Answers  


What is gui programming? : .NET Architecture

0 Answers  


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

0 Answers   MindCracker,






What are the different pipelining hazards? : Dot net architecture

0 Answers  


difference between Response.write,server.transfer and also which one is used when ?

0 Answers  


What is a clickonce application?

0 Answers  


what is a required field validation control?

2 Answers   Six Sigma,


Explain about code access security?

0 Answers  


Write a query Where,Groupby,having clauses?

2 Answers   iGate,


What is CLR,MSIL and Jit Compiler and their roll in .net

1 Answers   PCS,


Categories