SQL

SQL Ordering and Grouping

You can sort data retrieved from the database using SQL ordering and grouping queries. Ordering is most commonly used when wanted to sort records by a specific column in ascending or descending order. For example, if a database table has a ‘created_at’ column, you can order by this column to find out the most recent …

SQL JOINS

When using SQL JOINS within a query, you are combining rows from multiple tables into one result set based on the tables having a related column name.
The most common example of using SQL JOIN queries can be demonstrated by using a customers table and an orders table stored in the same database.
Let’s assume …

Get Started with SQL

SQL, or Structured Query Language, is a computer language aimed at querying relational databases. This post will show you how to get started with SQL, including learning the basic syntax of selecting, adding, updating and removing records from a database.
Firstly, note that SQL is case insensitive, which means using SELECT or select have the …