Important links -

Standard SQL boolean operator IS vs. equals (=) operator

SQL | Conversion Function | Implicit and Explicit conversions in SQL

When should I use semicolons in SQL Server?

MySQL has no square function. Use power(a,b).

SQL is string comparison is insensitive, means a=A is true.SQL server ignore case in a where expression

SQL Case Sensitive String Compare

SQL query for fetching records - find highest run scorer batsman from every team and his runs

How to make a select statement return null if no value is returned?

MySQL comparison with null value - we can't compare null values, most of the comparison results fails if record having null values

How to compare the current row with next and previous row in PostgreSQL?

How To Compare Successive Rows Within The Same Table in MySQL

Why the subtraction of two dates is different than the result from using DATEDIFF()?

When to use SQL Table Alias

MySQL JOIN ON vs USING?

Is a JOIN faster than a WHERE?

Difference between MySQL and MS SQL Server

Difference between <> and != in SQL