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 |
Can you explain server controls in atlas?
Explain the Lapsed Listener problem in .net
how to set the startup position of the form?
What are the five stages in a dlx pipeline? : Dot net architecture
what are constructors and destructors?
Why only boxed types can be unboxed?
Define the mesi? : Dot net architecture
Explain in-proc,out-proc and sql server.
4 Answers G7 CR Technologies, Ness Technologies,
How do I stop a thread?
how we can fire event in databound column in datagrid without using button?
What does the "EnableViewState" property do? Why would I want it on or off?
What is Object Caching in Visual Studio 2010?