SQL Interview Preparation/

...

/

Answer: Filter with the WHERE Clause

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:

Press + to interact
/* 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.

  • ...