Articles in this series
PRIMARY KEY The primary key constraint uniquely identifies each record. Primary keys must contain unique values and cannot contain NULL...
DATA TYPES IN SQL There are a lot of data types in SQL: But let's look into some important ones: INT A normal-sized integer that can be signed or...
Let's look at a table we have created. Let's select the age column MAX() FUNCTION It returns the maximum value present in a numeric column. MIN()...
DATE The date functions are used to insert dates into the database. It can also be used to extract date value from date expressions. TIME The time...
A formula is an equation designed by people in Excel. A function is a predefined calculation in Excel. FORMULA Let's look at this data...
SUM FUNCTION Returns the sum of elements in a column. The sum of non-contiguous cells SUMIF FUNCTION There are 3 kinds of cell references in...
