What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26983 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / guest
Having Clause is basically used only with the GROUP BY
function in a query. WHERE Clause is applied to each row
before they are part of the GROUP BY function in a query.
| Is This Answer Correct ? | 68 Yes | 4 No |
Post New Answer View All Answers
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is simple indexing method?
What is BCP? When does it used in sql server 2012?
Explain how would you store your query in an SSRS report or a Database server?
How to delete an existing row with delete statements in ms sql server?
Name few of the dcl commands in sql?
What is the difference between varchar and varchar types?
How would we use distinct statement? What is its use?
What are the different types of columns types constraints in the sql server?
What are the 7 disadvantages to a manual system?
How to delete duplicate rows in sql server?
What is the recursive stored procedure in sql server?
Explain ranking functions?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
How to count groups returned with the group by clause in ms sql server?
