sql questions and answers

Most Importan Question of SQL in Interview

by
Most Importan Question of SQL in Interview

Most Importan Question of SQL in Interview. If you are looking for most important question of SQL in the interview then you are the at right place landed on this website. In this website you will got idea about most important question of SQL which is help you to crack your interview in terms of … Read more

SQL Theory Interview Question for Fresher

by
database and sql interview questions

SQL Theory Interview Question for Fresher

SQL Theory Interview Question for Fresher, Dear fresher “Developers” here you going to get actual interview question for “Full Stack Developers”. These all question is give enogh knowleg and overview of SQL Theory Interview Question which help to you in your interview. So lets start.

Difference between Where and Having clause?

1.WHERE clause can be used with – Select, Insert, and Update statements, where as HAVING clause can only be used with the Select statement.

2. WHERE clause filters rows before aggregation (GROUPING), whereas, HAVING clause filters groups, after the aggregations are performed.

3. Aggregate functions cannot be used in the WHERE clause, unless it is in a sub query contained in a HAVING clause, whereas, Aggregate functions can be used in HAVING clause.

Read more