Please enable JavaScript to use CodeHS

CodeHS Glossary


Select General

A statement in SQL that allows you to ask for a row or multiple rows from a table in a database. SELECT * FROM House; (SELECT and FROM are key words, meaning they can’t be used for anything else like table names, column attributes, etc.) * chooses every column in the table; House is the name of the table SELECT name FROM House (returns the House table with only the name column) SELECT name, id FROM House (returns the House table with the name and id columns)