What is the difference between HAVING clause and the WHERE
clause?
Answer Posted / pallavi tiwari
in where clause the data that fetched in memory is according
to condition but in having the completed data firstly
fetched in memory and then seperated according to condition.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is snapshot replication?
Explain iaas, paas and saas?
How to count rows with the count(*) function in ms sql server?
How many levels of sp nesting is possible?
What are the advantages of using a stored procedure?
What is checkpoint in sql server?
What is difference between count (*) and count 1?
What happens if we shrink log file in sql server?
what is package and it uses and how can u call a package
What is the difference between getdate and sysdatetime?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Determine how to use the inserted and deleted pseudo tables?
Which are the new data types introduced in sql server 2008?
Can you explain what is indexed view? How to create it?