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
If no size is defined while creating the database, what size will the database have?
What is use of except clause?
We need to perform what steps in the following order to work with a cursor?
Can we write ddl in trigger?
How to make remote connection in database?
what is a self join? Explain it with an example? : Sql server database administration
What is efficiency data?
How to locate and take substrings with charindex() and substring() functions?
Explain the benefits of user-defined functions?
What do you understand by a stored procedure?
What are the different type of replication in sql server?
Explain “@@rowcount” and “@@error” in sql server?
How can sql server instances be hidden? : sql server security
What is a heap?
What do you understand by a view? What does the with check option clause for a view do?