Database Developer Question:
Download Job Interview Questions and Answers PDF
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.
Download Database Developer Interview Questions And Answers
PDF
| 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? |