What is the difference between having and where clause?
- 4 Answers
- 9706 Views
- I also Faced
- E-Mail Answers
Answer Posted / sd
Where clause operates on the selection before the rows are
actually grouped.
Hence , Try to add as many condition as possible in where
clause instead of having to boost the SQL query performance.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How do you make a trace?
What does the automatic recovery do?
How to replace the Query Result 'Null Value' with a text ?
What are a scheduled jobs or what is a scheduled tasks?
How to delete an existing row with delete statements in ms sql server?
Can we install sql server 2016 on windows 7?
What are the extra roles available in msdb? : sql server security
How to call stored procedure using http soap?
What is the temp table?
If a stored procedure is taking a table data type, how it looks?
What do you mean by table and field in sql?
Explain security with sql azure?
Define model database?
Explain the difference between cross join and full outer join?
What is snapshot parameter in ssrs?
