Write a query Where,Groupby,having clauses?
- 2 Answers
- 5724 Views
- iGate, I also Faced
- E-Mail Answers
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 |
what are the things we generally declare in session_start , application_start ?
Define an interrupt? : Dot net architecture
What is .net transaction?
Explain dma? : .NET Architecture
How to call .NET Web service from Java Appl. & Why ?
Hi, this is satish, i have more than 2 years of exp. on Microsoft .Net Technologies like C#, ASP.Net, VB.Net. But i am willing to change my platform into Testing tool. give me best suggestion for me.
How do I prevent concurrent access to my data?
6. Wcf- what is SOA
What are the main Tools to develop .Net Application?
What is the difference between machine config vs. Web config : Dot net architecture
What is cache coherency and how is it eliminated? : Dot net architecture
What is the difference between l1 and l2 cache? : Dot net architecture
Dot Net Framework 
