Explain basic SQL queries with SELECT from where Order By,
Group By-Having?
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 |
Post New Answer View All Answers
How to find the source of a table in sql server?
Can you move the resources after pausing the node? : sql server database administration
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Why SQL Agent is used?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
what's the difference between delete table and truncate table commands? : Sql server database administration
What are four major operators that can be used to combine conditions on a where clause?
What are the different ways you can create databases in sql server?
How to create a store procedure with encryption?
what is an index? : Sql server database administration
Differentiate between sql temp table vs table variable?
What’s the use of custom fields in report?
What do mean by xml datatype?
Does the order of columns in update statements matter?
How to disable stored procedure sql server?