Ad
hidayatf6vs.rishadharis

Basic Filtering 7 Is (BIE)

Code
Diff
  • -- Code Here
SELECT * FROM transactions
where customer is NULL;
    • --- Code Here
    • -- Code Here
    • SELECT * FROM transactions
    • where customer is NULL;
hidayatf6vs.rishadharis

Basic Filtering 5 Not In (BIE)

Code
Diff
  • SELECT 
* 
FROM transactions
WHERE store NOT IN ('BIE Store Jakarta','BIE Store Bandung')
    • -- Code Here
    • SELECT
    • *
    • FROM transactions
    • WHERE store NOT IN ('BIE Store Jakarta','BIE Store Bandung')