Quote:
Originally Posted by sakitram
SELECT max(date_time) FROM emp_monthly_sales group by emp_id.
|
this is syntactically correct, but not semantically
it does give you a result set of dates, and they do happen to be the last date for each employee, however, all you get is the dates... so this query has a very serious logical shortcoming -- you can't tell whose dates they are!!