Page 72 - SQL
P. 72

Result



          Id  FirstName      LastName

          1   Ozgur          Ozturk




        Purpose



        EXISTS, IN and JOIN could sometime be used for the same result, however, they are not equals :


            •  EXISTS should be used to check if a value exist in another table
            •  IN should be used for static list
            •  JOIN should be used to retrieve data from other(s) table(s)

        Read EXISTS CLAUSE online: https://riptutorial.com/sql/topic/7933/exists-clause
































































        https://riptutorial.com/                                                                               54
   67   68   69   70   71   72   73   74   75   76   77