SQL: Select, Where, From

Select, Where, From

Introduction

The first thing we have to learn when starting to work with databases is how to look inside of them and see specific tables and ultimately – specific columns or rows from those tables. In order to do this, we need to write a query, which is just a request for data from a database. More precisely, we have to use the SELECT, FROM, and possibly WHERE statements in order to get the wanted data from the table. In this tutorial, we will take a look at some basic SELECT queries and some basic filtering using the WHERE clause. All the examples in this tutorial will be based on the table shown below. The name of the table is Person.