What is the difference between having and where clause?
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 to stop log file growing too big?
Which tools are available to manage SQL Azure databases and servers?
What is the contrast between sql and mysql?
How to create a login account in ms sql server to access the database engine using "create login" statements?
Explain the commands in sql server?
What is deploy, process and build? : sql server analysis services, ssas
What is the Main Difference between ACCESS and SQL SERVER?
What is mscorsvw.exe - process - microsoft .net framework ngen?
What stored by the model? : sql server database administration
Which table keeps the locking information?
Which tcp/ip port does the sql server run on? How can it be changed?
What is sql server locking?
What is difference between order by and group by?
What is auditing in sql server?
Why olap is used?