SQL Formatting

How to format SQL Query to spot errors easily

Format your SQL query using these tips. You can spot errors easily and quickly.

How to Avoid Group By Errors

How to Use COUNT and GROUP BY Correctly in SQL

SQL count(*) in query is little tricky. This post explains why you need to use group by along with count aggregate function