3 Comments on “How many rows does the SQL statement return?”

1. Jain says:

   February 27, 2017 at 9:58 pm

   C

   
   
   
   0

   
   
   
   0
2. askarne brahim says:

   January 2, 2018 at 1:59 pm

   way not B 2

   
   
   
   0

   
   
   
   0
3. avalon333 says:

   November 12, 2018 at 10:49 am

   I build this query and the result is this:

   NORMAL JOIN, gives 2 rows

   LEFT JOIN, gives 3 rows

   The LEFT JOIN keyword returns all records from the left table (Cars), and the matched records from the right table (Color). So i actually see this:

   Sedan 2-door 2 Gold 2
   Truck 4-door NULL NULL NULL
   Minivan 3-door 1 Red 1

   = 3 records

   
   
   
   6

   
   
   
   0