Skip to content

Latest commit

 

History

History
5 lines (4 loc) · 334 Bytes

subqueries_in_where.md

File metadata and controls

5 lines (4 loc) · 334 Bytes
Raw

Subqueries in Where Clause

  • A subquery in the WHERE clause can be used to filter the main query
  • Joining tables in where clause: you just need to add the 2 tables in the FROM clause and define the relational condition between both in the WHERE clause (WHERE table1.x = table2.y)
  • Some useful filtering keywords: all, exists, any