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

What is the primary use of the model database?

1077

Can you edit the .rdl code associated with a linked report?

162

What is function of CUBE ?

1030

What is the impact on other user sessions when creating indexes?

918

Are semicolons required at the end of sql statements in sql server 2005?

982

Explain triggers?

993

How to download and install the scaled-down database adventureworkslt?

984

What is SQL Azure Firewall?

136

What is database dimension? : sql server analysis services, ssas

1070

What are the steps you must follow to hide sql server instances?

970

Explain cursor as data base object?

1030

What are trace flags?

1022

What is change data capture (cdc) feature?

1050

what are the new features introduced in sql server 2000? : Sql server database administration

905

What is store procedure?

1050