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
Do you know what are acid properties of transaction?
Tell me what is difference between clustered and non clustered index?
Explain cross join or cartesian product in sql?
Can we call stored procedure in view in sql server?
Why SQL Agent is used?
Explain how you can deploy an SSRS report?
Which rendering formats are affected by the pagesize properties?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Does transparent data encryption provide encryption when transmitting data across the network?
what is a join? : Sql server database administration
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
How to provide default values to stored procedure parameters?
What is CTE in SQL
How to start and end transact-sql statements?
Explain what is lock escalation?