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 the use of virtual, sealed, override, and abstract.
Explain .net mobile input controls? : Microsoft dot net mobile
Explain some of the disadvantages due to microsoft.net?
question related to table havi colspan and row span
11. diff b/w Dll and Exe
What is Opf3
which control is used to compare two controls?
how to make and display a form without title bar?
how can u manage sessions ?
Define dma? : Dot net architecture
What are the options provived by vss to the user? how it will help us while delevoping application?
how to minimize,maximize and restore my form programmatically?
1 Answers Interlac, Six Sigma,