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 |
What is WPF and WCF?
What is static Constructor?
which control is used to compare two controls?
What are library functions?
Explain different pipelining hazards and how are they eliminated? : Dot net architecture
How does an appdomain get created?
can any one urls for learning .net(which is written in simple english)
how to change the title of my window?
Why the config file might not be writable
How will you do windows authentication and what is the namespace?
Explain dotnet framework ?
question related to table havi colspan and row span