What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26987 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / saisri
Where clause is used prior the grouping of data,
where as Having is used after grouping the result of the
data.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
How to Check if table exists in sql server?
What does the update command do?
how to use DTS package in 2000,2005,2008 in sql server
What is report snapshot in ssrs?
Differentiate sql server reporting services vs. Crystal reports?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How to copy data from one table to another table?
What does it mean to invest in the index?
Explain log shipping?
Explain transaction server isolation?
What is the language structure to add a record to a table?
What is difference between rownum and row_number?
Describe the functionalities that views support.
