Help for this page

Select Code to Download


  1. or download this
    CREATE TABLE friends (Nickname VARCHAR(40), Name (First VARCHAR(20), L
+ast Varchar(20))
  2. or download this
    SELECT * FROM friends WHERE Name=('John', 'Smith')
  3. or download this
    SELECT * FROM friends WHERE Name.First='John'
  4. or download this
    SELECT Nickname FROM friends WHERE Name.First='John'