Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

SELECT FROM statement

Theory

Census

Report a typo

A table is defined by the following statement:

CREATE TABLE Census (id INTEGER, 
                     name VARCHAR(20), 
                     birth_year INTEGER, 
                     gender VARCHAR(1));

Write a query that selects all the columns without the usage of a * symbol.

Write an SQL statement





___

Create a free account to access the full topic