From 4a83bb1a6d5bee0892c294467618bd66b88535a7 Mon Sep 17 00:00:00 2001 From: David Luevano Alvarado Date: Sat, 5 Jun 2021 22:41:32 -0600 Subject: prettify css add support for wrap images and img/art grids --- blog/dst/a/sql_video_notes.html | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'blog/dst/a/sql_video_notes.html') diff --git a/blog/dst/a/sql_video_notes.html b/blog/dst/a/sql_video_notes.html index 867c265..9205eb6 100644 --- a/blog/dst/a/sql_video_notes.html +++ b/blog/dst/a/sql_video_notes.html @@ -22,7 +22,7 @@ - + @@ -190,10 +190,12 @@
  • RIGHT (OUTER) JOIN: returns all records from the right table, and the matched records from the left table.
  • FULL (OUTER) JOIN: returns all records when there is a match in either left or right table.
  • +

    INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN

    +

    Nested queries

    A query composed of multiple select statements to get a specific piece of information. This is self explanatory, you do a SELECT query somewhere inside another one, for example SELECT ... IN (SELECT ...), where the nesting is occurring inside the parenthesis after the IN statement.

    A nesting isn’t constrained to the IN statement, it can appear anywhere, for example in a WHERE statement: SELECT ... WHERE something = (SELECT ...).

    @@ -222,7 +224,7 @@

    By David Luévano

    Created: Tue, Mar 02, 2021 @ 14:35 UTC

    -

    Modified: Sun, Jun 06, 2021 @ 00:22 UTC

    +

    Modified: Sun, Jun 06, 2021 @ 03:41 UTC