Conditional Queries

A conditional query retrieves data that meets the conditions.

The following example demonstrates a typical conditional query that displays the query results in a specified table based on specific query conditions:

-- Create a table and insert data into the table.
gaussdb=# CREATE TABLE test_grade(
    id INT, 
    name VARCHAR(20),
    score FLOAT       -- Score
);
gaussdb=# INSERT INTO test_grade VALUES (1,'Scott',90),(2,'Jack',87.5),(3,'Ben',48);

-- Query information about students who fail to pass the test.
gaussdb=# SELECT * FROM test_grade WHERE score < 60;
 id | name | score 
----+------+-------
  3 | Ben  |    48
(1 row)

-- Drop.
gaussdb=# DROP TABLE test_grade;