Jump to content


Photo

select query


  • Please log in to reply
No replies to this topic

#1 chinni

chinni
  • Members
  • Pip
  • Newbie
  • 4 posts

Posted 03 February 2003 - 01:39 AM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users