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 do I trace a query in sql server?
What are the five major components of a dbms?
What is always encrypted?
Can you explain important index characteristics?
What is the synonym of join?
What are the benefits and tasks of object explorer? : sql server management studio
between cast and convert which function would you prefer and why?
Explain the microsoft sql server delete command?
Equi join and non equi join is possible with sql server?
Mention a few common trace flags used with sql server?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
In case you have filters in your report, when filters will be applied in cached report instance?
How to get a list all databases on the sql server?
Do you know what is blocking?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration