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 develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile

0 Answers  


What i sthe meaning of .(dot) in .Net?

9 Answers   HCL,


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

1 Answers   Chevron,


Explain the difference between primary & secondary storage device? : .NET Architecture

0 Answers  


What is a Windows Service and how does its lifecycle differ from a "standard" EXE?

2 Answers   Siebel Systems,






Can you explain control extenders?

0 Answers  


What is a managed code? : Dot net architecture

0 Answers  


What is msil, and why should my developers need an appreciation of it if at all?

0 Answers  


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.

4 Answers   Honeywell,


What is a managed code is dim fs as filestreamobject is a managed code? : .NET Architecture

0 Answers  


Explain the race around condition? How can it be overcome? : Dot net architecture

0 Answers  


what are the events for a form?

0 Answers   Six Sigma,


Categories