Tell us what is the difference between Having and Where clause?
Submitted by: MuhammadWhere 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.
Submitted by: Muhammad
Submitted by: Muhammad
Read Online Database Developer Job Interview Questions And Answers
Top Database Developer Questions
| ☺ | Please explain what is Database Testing? |
| ☺ | Explain me what are the different DDL commands in SQL? |
| ☺ | Tell us what is a temp table? |
| ☺ | Tell me what is a Composite PRIMARY KEY? |
| ☺ | Do you know SQL Data Types? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
