Jump to content

Archived

This topic is now archived and is closed to further replies.

chinni

select query

Recommended Posts

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.