Database: SELECT Rows - Introduction

The SELECT command can be used with one table to select rows that meet some criterion for the resulting table. This uses the Student table. The FROM clause specified the table(s) and the WHERE clause specifies conditions that a row must satisfy to be included in the result.

Selecting rows with arithmetic comparison

To get all students with a GPA greater than or equal to 3.0.

SELECT *
    FROM Student
    WHERE student_gpa >= 3.0;

Result:

student_id	student_fname	student_lname	student_gpa
4	Minnie	Mouse	3.8
3	Peter	Rabbit	3.6

There may even be no results. For example,

SELECT *
    FROM Student
    WHERE student_gpa >= 4.0;

Result:

student_id	student_fname	student_lname	student_gpa

Nothing is selected.

Selecting columns and rows

Column selections and comparisons can both be done. The result doesn't have to display columns that were compared.

SELECT student_lname, student_fname
    FROM Student
    WHERE student_gpa >= 3.0;

Result:

student_lname	student_fname
Mouse	Minnie
Rabbit	Peter