Database Developer Question:
Tell us what is the difference between Having and Where clause?
Answer:
Where clause is used to fetch data from a database that specifies particular criteria whereas a Having clause is used along with ‘GROUP BY’ to fetch data that meets particular criteria specified by the Aggregate functions. Where clause cannot be used with Aggregate functions, but the Having clause can.
| Previous Question | Next Question |
| Tell me which TCP/IP port does SQL Server run? | Tell me what are the three ways that Dynamic SQL can be executed? |