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 about code access security?
what is the use of SQL command builder class in C#.net? Explain how can we execute a stored procedure using C#.Net? What is the difference between .DLL and .EXE?
what is the method while we are using adapter and dataset ?
What is the mesi? : Dot net architecture
how to change the title of my window?
What is the purpose of cache? How is it used? : Dot net architecture
Explain about continuable exceptions?
what are ACID properties ?
What does the "EnableViewState" property do? Why would I want it on or off?
while developing a asp.net 2.0 ajax application how to maitain and check the ACID property for each transaction
hi, kindly send WWF(.net 3.5) pdf notes to my id. thanx in advance, chays
Explain cache memory? : Dot net architecture