Guest User

Setup

a guest
Jun 23rd, 2022
237
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. CREATE TABLE Users (
  2. USERID VARCHAR(5),
  3. TS DATE,
  4. [ACTION] VARCHAR(1) )
  5. GO
  6. INSERT INTO Users
  7. SELECT 'USER1', '2022-06-14', 'A' UNION ALL
  8. SELECT 'USER2', '2022-06-15', 'A' UNION ALL
  9. SELECT 'USER2', '2022-06-15', 'B' UNION ALL
  10. SELECT 'USER1', '2022-06-23', 'A' UNION ALL
  11. SELECT 'USER3', '2022-06-23', 'B'
  12. GO
Advertisement
Add Comment
Please, Sign In to add comment