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

Why do we need normalization?

931

How to see the event list of an existing trigger using sys.trigger_events?

1075

Explain what are magic tables in sql server?

998

What is replication and database mirroring?

1048

Characterize join and name diverse sorts of joins?

968

How to backup encryption key ?

183

How to locate and take substrings with charindex() and substring() functions?

1016

What command do we use to rename a db, a table and a column?

927

What are the 2 types of classifications of constraints in the sql server?

1124

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1027

Can binary strings be converted into numeric or float data types?

1038

What are the restraints imposed on the table design by a merge replication?

1038

What is the process of indexing?

1009

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1108

How to enter binary string literals in ms sql server?

1164