EE-Learning
More complex queries with AND/OR
Catogry:
Computing
Subject:
Computer Programming
Course:
Intro To SQL: Querying And Managing Data
Lecture List
Altering tables after creation
Changing rows with UPDATE and DELETE
Combining multiple joins
Joining tables to themselves with self-joins
Joining related tables with left outer joins
JOINing related tables
Calculating results with CASE
Restricting grouped results with HAVING
Querying IN subqueries
More complex queries with AND/OR
S-Q-L or SEQUEL?
Aggregating data
Querying the table
Creating a table and inserting data
Welcome to SQL