Lists

• Can save a lot of typing!

• Can use a list or a sub query
  List example:Select au_lname, au_fname from authors where state in (‘CA’, ‘IN’, ‘MD’)
  
  SubQuery Example:Select pub_name from publishers where pub_id in (select pub_id from titles where total_sales > 3000)

Previous slide

Next slide

Back to first slide

View graphic version