Write a query Where,Groupby,having clauses?
Answers were Sorted based on User's Feedback
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 |
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 |
Explain How to improve the cache performance? : Dot net architecture
What is the problem with .net generics?
How can a win service developed in .NET be installed or used in Win98?
What is gui programming? : .NET Architecture
What is the difference between absolute expiration and sliding-time expiration?
What are the different pipelining hazards? : Dot net architecture
difference between Response.write,server.transfer and also which one is used when ?
What is a clickonce application?
what is a required field validation control?
Explain about code access security?
Write a query Where,Groupby,having clauses?
What is CLR,MSIL and Jit Compiler and their roll in .net