select userid from usertable where username like '%raj%' group b

Write a query Where,Groupby,having clauses?

Question Posted / reddy

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Explain dotnet framework ?

1044

How can we perform data binding in atlas?

936

What are different types that a variable can be defined and their scopes ?

1056

Define cache? : Dot net architecture

959

How cache is used? : Dot net architecture

1001

State the different levels of exceptional safety?

1000

Whate are resource files? How are they used in .net?

923

What is different about namespace declaration when comparing that to package declaration in java?

1041

Explain dma? : .NET Architecture

956

Explain hard disk and what is its purpose? : Dot net architecture

954

What is IL code, CLR, CTS, GAC & GC?

1033

Why only boxed types can be unboxed?

1093

What is .net mobile utility controls. : Microsoft dot net mobile

978

What's new in the .net 2.0 class library?

927

Does .NET runtime offer Deterministic Destruction or not?

1025