Cloud Database Development and Management

204  ◾  Cloud Database Development and Management

table name STUDENT are capitalized for clarity purposes. Also, you do not have to break the

SELECT statement into two lines. If you write the statement as SELECT * FROM STUDENT

in a single line, it is perfectly acceptable. Breaking an SQL statement into multiple lines makes it

easier to read. e query result is shown in Figure 6.14, which lists the data of every row and every

column in the table STUDENT.

To retrieve data in certain rows specified with conditions, the WHERE clause is added to the

SELECT statement. e search condition is defined in the WHERE clause. For example, to query

the student ...