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 temporary stored procedure?

895

What is ssl in sql server?

1010

Explain use of expression builder.

945

how you can deploy an ssrs report?

172

Explain DBCC?

907

What is nested transaction?

1038

what is denormalization? : Sql server database administration

876

How many null values we can have in a unique key field in sql server?

902

In case you have filters in your report, when filters will be applied in cached report instance?

103

What will be the maximum number of index per table?

947

What is advantage data architect?

864

Can binary strings be used in arithmetical operations?

879

how to trace the traffic hitting a sql server? : Sql server database administration

1766

What are database states in ms sql server?

1111

Can multiple columns be used in sql group by clause in ms sql server?

980