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 give an example of when it would be appropriate to use a web service as opposed to a non-serviced .NET component
What are different types that a variable can be defined and their scopes ?
IS IT Possible to inherit the AJAX page from child class which(child) is inherit from page class.Because i should apply some security in child class
what is the method while we are using adapter and dataset ?
Define pipelining? : Dot net architecture
How to delete the duplicate records from table(having bulk records)?
Define a managed code? : Dot net architecture
Do you know textbox and textview controls of .net mobile? : Microsoft dot net mobile
Explain How to improve the cache performance? : Dot net architecture
What does the "EnableViewState" property do? Why would I want it on or off?
Explain domestic architecture artifacts? : Dot net architecture
What is a service class?