Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT t2 . *
- FROM t2
- LEFT JOIN t2 AS tt2 ON tt2.acct = t2.acct
- WHERE t2.create_date < tt2.create_date
- acct create_date
- 1 2012-01-20 03:12:34
- 1 2012-01-20 03:12:34
- 1 2012-02-04 13:34:45
- 2 2012-01-09 12:42:56
Add Comment
Please, Sign In to add comment