Learning SQL Made Simple: Understanding SELECT and WHERE

 When students begin learning SQL, two of the most important keywords they come across are SELECT and WHERE. These commands form the backbone of querying data from a database. The handwritten notes page on “SELECT Statement and WHERE Clause in SQL” is designed to make these concepts easy to understand, remember, and apply—especially during exams.

The SELECT Statement: Getting Data from a Table

The SELECT statement is used whenever we want to retrieve data from a database table. In simple terms, SELECT tells the database what data we want to see.

SELECT column1, column2

FROM table_name;

``

• SELECT specifies the columns we want
• FROM specifies the table where the data is stored

The notes also explain an important shortcut:

• SELECT * means select all columns from the table

---

The WHERE Clause: Filtering the Data

While SELECT chooses the data, the WHERE clause helps narrow it down. WHERE is used to filter records based on a specific condition. Instead of retrieving all data, WHERE allows us to get only the rows that match our requirement.

SELECT * FROM Students WHERE age > 18;

``

SELECT name FROM Students WHERE name LIKE 'A%';

---

Common WHERE Operators Explained Simply

One of the most helpful sections in the handwritten page is the list of WHERE operators. These operators are essential for writing conditions, and the notes explain them clearly:

• = (equal to) – matches exact values
• > (greater than) – finds values above a number
• < (less than) – finds values below a number
• LIKE – used for pattern matching (such as names starting with a letter)
• BETWEEN – used to check values within a range