SELECT
SELECTExecute the following the SQL when you want to take out the specific columnsfrom the table:SELECT Item, Item, ・・・ FROM TableNameIf there are multiple columns you want to take out, set apart them by a comma.For example, the SQL to take out the math scores from the "Grade" table isas follows.SELECT Math FROM GradeAlso, if you write "DISTINCT" immediately after "SELECT", you can take outthe rows excluding duplicate rows. For example, the SQL to take out the mathscores from the "Grade" table without duplication is as follows.SELECT DISTINCT Math FROM Grade■Designating conditionsIf you want to take out the rows that match the conditions, write "WHERE"as following SQL.SELECT Item, ・・・ FROM T
0