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 a covered index?

893

Define self join?

989

What is pivot and unpivot?

978

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

962

What do you understand by the denormalisation?

911

What is Service Broker in sql server 2012?

972

Mention the different types of replication in sql server.

962

What are the purposes and advantages stored procedure?

890

What is amo? : sql server analysis services, ssas

1046

List all the types of user-defined functions?

994

Do you know what are acid properties?

1018

What are the advantages of partitioning?

1047

What is difference between inner join and join?

986

Explain a join?

1008

What are cursors stored procedures and triggers?

938