Advertisement
Guest User

Untitled

a guest
Feb 11th, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. SELECT DateOfPurchase,
  2. TypeOfFruit,
  3. Quantity
  4. FROM FruitInventory
  5. WHERE TypeOfFruit = 'apple' OR
  6. TypeOfFruit = 'orange' OR
  7. TypeOfFruit = 'banana'
  8.  
  9. MAX(DISTINCT DateOfPurchase)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement