What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
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
When does a workload on SQL Azure get throttled?
How to manipulate data from one table to another table ?
How to execute stored procedure in select statement sql server?
Can sub report data source be different from that of the parent report?
What stored by the msdb? : sql server database administration
What is SQL Azure Federations?
How to create a ddl trigger using "create trigger" statements?
What are the different types of indexes?
Why use sub query in sql server and list out types of sub queries?
System variable and temporary variables
Difference between group by clause and having clause in SQL?
What are data regions?
Equi join and non equi join is possible with sql server?
What is replication with database mirroring? : sql server database administration
how can you check the level of fragmentation on a table? : Sql server administration