Write a query Where,Groupby,having clauses?
- 2 Answers
- 5077 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 |
Does .NET runtime offer Deterministic Destruction or not?
Is .NET really support fully OOP Concept?
Explain difference between state server and sqlserver? : .NET Architecture
Does application frame need host?
which is the institute in hyderabad for providing the live project industry training
How to improve the cache performance? : Dot net architecture
how to display a message box in the Application?
What other than biginteger has been introduced in system.numerics namespace?
how windows applications different from the console applications?
What is Video Streaming in .net??
What is IL code, CLR, CTS, GAC & GC?
Different types of authentication modes in .net framework ?
Dot Net Framework 
