Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between having and where clause?
- 4 Answers
- 10547 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
What is the function of sql server agent windows service?
Can binary strings be used in arithmetical operations?
What stored by the model? : sql server database administration
How can you fetch alternate records from a table?
What's new in sql management studio for sql server? : sql server management studio
What is self contained scalar sub query?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
Give a example to search fr a string in all stored procedure in sql server.
What is role playing dimension with two examples? : sql server analysis services, ssas
What is an execution plan?
What is the difference between char and varchar2 datatype in sql?
What is 1nf normalization form?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What are wait types?
What are points to remember while using the fillfactor argument?
