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
What is local temp table?
what is the primary use of the model database? : Sql server administration
explain how to create a new schema in a database? : Sql server database administration
What is RAID? What are the different types of RAID configurations?
What are the steps you must follow to hide sql server instances?
Explain the steps needed to create a scheduled job?
Explain transaction server explicit transaction?
Explain the rules for designing files and file groups in sql server?
what purpose does the model database serve? : Sql server database administration
What is the contrast between sql and pl/sql?
What is wide table?
Can you explain full-text query in sql server?
What is log ldf?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain triggers?