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

How to improve the cache performance? : Dot net architecture

972

What is a virtual memory? : Dot net architecture

1008

Explain the purpose of cache? : Dot net architecture

949

Why the config file might not be writable

1203

Differnce between managed code and unmanaged code ?

1134

Explain different pipelining hazards? : Dot net architecture

1039

What are bindings?

1050

What is the mesi? : .NET Architecture

1069

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

966

Define a virtual memory? : Dot net architecture

952

deference between display and visibility property of CSS

2319

I want to create a project like google maps how can we do that with atlas?

994

So what exactly is the configuration file for then?

1010

what are the events for a form?

2145

What is the cli? Is it the same as the clr?

1012