Selecting Data From Table

• Most basic database processing is querying a table for data

• SQL SELECT statement is simple:

  SELECT Name, City FROM People
  

• Retrieves all records from PEOPLE table, returning all values for NAME and CITY columns

  • can list as many or as few columns as needed

Previous slide

Next slide

Back to first slide

View graphic version