Author Archives: user

SQL – Date & Time Table of content SQL provides multiple datatypes and functions to handle Date and Time values in a database. This is because Date and Time values are represented in various formats. For instance, there are two common ways to represent a date value: DD/MM/YYYY and MM/DD/YYYY. Similarly, there is more than […]

SQL – Auto Increment Table of content The SQL Auto Increment is used to automatically add unique sequential values into a column of a table. We usually define the Auto Increment on a column while creating a table. And when we insert new records into the table, the unique values are added to them. When […]

SQL – Group By vs Order By Table of content In SQL, we have two commonly used clauses that help us to manipulate data; Group By clause and Order By clause. A Group By clause is used to arrange the identical data/records into groups and the Order By clause is used to sort the data […]