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 |
In LINQ TO SQL if it is possible to select the top 5 records from the particular table using select top 5.
What is one way operation?
Difference between type constructor and instance constructor?
How to implement the display in the class printdoc (how to resolve the naming conflict) a: no naming conflicts
How to delete the duplicate records from table(having bulk records)?
What is .net mobile lists. Explain with an example? : Microsoft dot net mobile
Explain the five stages in a dlx pipeline? : .NET Architecture
how to make and display a form without title bar?
Explain some of the disadvantages due to microsoft.net?
Use of Enable view state ? if turn off what happen ?
What is WPF and WCF?
What is the cli? Is it the same as the clr?