In above select stmnt city must be in group by clause. Otherwise it'll

Explain basic SQL queries with SELECT from where Order By,
Group By-Having?

Question Posted / ranjan

Answer Posted / ranjan

In above select stmnt city must be in group by clause. Otherwise it'll sho error.

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to find the source of a table in sql server?

947

Can you move the resources after pausing the node? : sql server database administration

1056

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1166

Why SQL Agent is used?

1087

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2734

what's the difference between delete table and truncate table commands? : Sql server database administration

946

What are four major operators that can be used to combine conditions on a where clause?

1010

What are the different ways you can create databases in sql server?

1070

How to create a store procedure with encryption?

970

what is an index? : Sql server database administration

950

Differentiate between sql temp table vs table variable?

850

What’s the use of custom fields in report?

906

What do mean by xml datatype?

1034

Does the order of columns in update statements matter?

879

How to disable stored procedure sql server?

1554