nanakswali

Join on last row

Feb 5th, 2019
7,180
0
Never
2
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.21 KB | None | 0 0
  1. SELECT c.*, p.*
  2. FROM customer c
  3. JOIN purchase p1
  4.  ON (c.id = p1.customer_id)
  5. LEFT OUTER JOIN purchase P2 ON (c.id = p2.customer_id AND (p1.date < p2.date OR p1.date = p2.date AND p1.id < p2.id))
  6. WHERE p2.id IS NULL
Advertisement
Comments
  • User was banned
  • User was banned
Add Comment
Please, Sign In to add comment