DATE calculation in SQL is tricky. Sometimes you need to find Day name, Day of the week, and Next Day Date. These example SQL queries useful for you.
This post covers how to use WHERE and DELETE in sub-queries. Useful examples to refer to quickly.
I have explained how to format DATE by using views.
Simple ideas and quickly what you need to find to write a query for joining of two tables explained.
In this post, I have answered one tricky SQL-view interview question. Views availability after the base table modified confuses many developers. I provided an answer to this.
I have explained on how to give multiple conditions in the SQL WHERE clause with examples
Explained examples on SQL Right and Left functions to handle Strings and to get Substring correctly.
Explained the top ideas on how to insert values into a new table using SELECT and INSERT in SQL
How to embed SQL and establish connection in Python, Java and C# well explained.
Explained the best SQL example of NOT NULL constraint.
Ideas on how to write a sub query quickly in your projects.
Two top methods to JOIN tables with Using and ON. Here are useful SQL queries to understand quickly.