|< < 42 > >|

The select statement

select all columns

Convenient syntax to keep all columns.
select * from album where year >= 1970 and year < 1980

album		select * from album where year >= 1970 and year < 1980
album_id artist_id title year label_id 1001 7001 My Aim is True 1977 6001 1002 7001 This Year's Model 1978 6001 1003 7002 Mink, Rat or Rabbit 1998 6002		album_id artist_id title year label_id 1001 7001 My Aim is True 1977 6001 1002 7001 This Year's Model 1978 6001

|< < 42 > >|