SHARE
TWEET

hhquest

a guest Sep 16th, 2019 107 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. span class="re5"> create table products(produсtname string, categoryname string);
  2.  
  3. insert into products values("milc", "drink");
  4. insert into products values("milc", "cow product");
  5. insert into products values("milc", NULL);
  6. insert into products values("beer", "drink");
  7. insert into products values("beer", NULL);
  8. insert into products values("beer", "alcohol");
  9. insert into products values("liquor with milk", "alcohol");
  10. insert into products values("liquor with milk", "cow product");
  11. insert into products values("liquor with milk", NULL);
  12.  
  13.  
  14. select produсtname,categoryname from products where produсtname = "beer" AND (categoryname = "alcohol" OR categoryname IS NULL);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top