Quote:
Originally Posted by r937
lolz, you are persistent, aren't you
okay, here's what i was looking for:
Code:
SELECT emp_id
, MAX(dt) AS latest_date
FROM emp_monthly_sales
GROUP
BY emp_id
latest date per employee
simple, yes? |
it's simple.. thanks.
Quote:
Originally Posted by r937
please study it carefully and let me know when we can proceed to the second stage because we'll be using this exact query as part of it
|
please let's proceed to the next stage..