sql query

well, If i have a table structure like this:

Article_id sub theme_id Article_name
1 1 A Notable
2 1 Doctor
3 2 is not
4 3 able to
5 3 do an
6 3 operation
7 4 because he
8 4 has no table

So, here, the last entered article name for sub theme_id 1 is "Doctor" and for 2 is "is not", for 3 is "operation" and for 4 is "has no table".

Now, i want to display the last entered artcile names for each sub-theme id.

Well, how can i write my sql query??

Thanks everybody.

Depends on the database.

I'll guess mysql, which allows you to do something horrible like -

SELECT article_id, subtheme_id, article_name, max(article_id) AS lastarticle
FROM article
GROUP BY subtheme_id
HAVING max(article_id) = lastarticle

Or replace article_id with article_date - primary keys should not be used in the above manner.

seems to be not working.Any ideas pls??

Thank you