Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between having and where clause?
- 4 Answers
- 10322 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 to declare and use cursor variables?
What stored by the msdb?
what are acid properties? : Sql server database administration
How will you monitor replication latency in transactional replication? : sql server replication
What are system databases in ms sql server?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Where views are stored in sql server?
How do you delete a trigger?
What is the fillfactor concept in indexes?
Write a sql query to sort on different column name according to the parameters passed in the function?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is the difference between for xml raw and for xml auto?
What is an identity?
What does it mean to normalize data?
Explain features and concepts of analysis services?
