Topic: select query

[chinni]

Oops, I\'m wrong in my previous post:

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 record 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 records for each sub-theme id.

Well, how can i write my sql query??

Thanks everybody.