Search⌘ K
Home/
Courses/
SQL Interview Preparation

Answer: Filter with the WHERE Clause

Find a detailed explanation of how to filter records using an SQL query.

We'll cover the following...

Solution

The solution is given below:

MySQL
/* The query to find the student records for st-104 */
SELECT * FROM StudentGrades 
WHERE  StudentID = 'st-104';

Explanation

The explanation of the solution code is given below:

  • Line 2: The SELECT query selects all the columns using the * wildcard. The FROM clause specifies the table name as Students.

  • Line 3: The WHERE clause specifies the condition on which we want to retrieve the data from the table. ...