I hope someone can help me creating a sql for the purpose i have.
I have a table named case_score_t with these columns:
id, case_id, user_id, score, created_date
I am interested in picking the rows with the greatest created_date, for a certain user_id.
I now this SQL with give me the result:
SELECT *, max(created) FROM case_score_t cs WHERE cs.user_id = 1449 GROUP BY cs.case_id;
The problem is that i have is that i get an extra column, the max(created) column back.
Is there anyway to do the same query(maybe with subselect's or something), without getting the extra column.
So basically i want something like:
SELECt * FROM ...... and is should return the same result.
Thanks in advance.