COMPSCI 61A Lecture 33: Lecture 33 (11/15/17)

• School: Berkeley
• Department: Computer Science
• Course: COMPSCI 61A
• Professor: De Nero John

Document Summary

Two tables a and b are joined a comma to yield all combos of a row from a and a row. Where child = name and fur = curly . Two tables may share a column name; dot expressiosn and aliases disabiguate column. Select all grandparents with the same fur as grandchilden. Select [columns] from [table] where [condition] order by [order]; [table] is a comma-separated list of table names with optional aliases. Select a. parent as granddog, b. child as granpup from parents as a, parents as b. Where a. parent = b. parent and a. child < b. child. A. child < b. child will take care of repeats. Expression can contain function calls to arithmetic operators. Select [columns] from [table] where [expression] order by [expression] Combine values: + , -, *, / , % and, or. Compare values: , > = <> != , = Select name from cities where latitude >= 43: String values can be combined to form longer strings.