How to format SQL Query to spot errors easily
Format your SQL query using these tips. You can spot errors easily and quickly.
Category: SQL
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
Resources you need to practice MySQL online
In this post I have given top online resources where you can do practice of MySQL without install it on your laptop.
String Functions Useful for smart SQL Queries
Useful string functions for smart SQL developers to write better queries. Useful to read now.
3 Super ideas on Tuning SQL Query
I have given three ideas to improve SQL performance in this post. Quickly you can implement in your project.
DB2 DATE example SQL Queries to your project
SQL DATE and Time comparison popular styles and SQL queries useful to read for your project.
The Order of SQL Query Execution Read Today
SQL Order of execution is sequence of steps. The database executes each Query in a particular order. Read more.
Sample SQL ALTER queries useful for your project
SQL ALTER statement you can use to add columns to existing TABLE in RDBMS. Not only TABLE you can read all database object where you can use ALTER.
