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 develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile
What i sthe meaning of .(dot) in .Net?
Hi i need fast track course maximum to complete within a month....courses are Asp.net,c3,vb.net n sql server........at hyderbad location ..best institute n cost
Explain the difference between primary & secondary storage device? : .NET Architecture
What is a Windows Service and how does its lifecycle differ from a "standard" EXE?
Can you explain control extenders?
What is a managed code? : Dot net architecture
What is msil, and why should my developers need an appreciation of it if at all?
which of the following statement is true about gac. a)it is being handled by .net framwork b)It is special folder c)it can have files with same name etc etc.
What is a managed code is dim fs as filestreamobject is a managed code? : .NET Architecture
Explain the race around condition? How can it be overcome? : Dot net architecture
what are the events for a form?