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.