阅读背景:

选择每个类别中时间戳最大的行

来源:互联网 

I have a MySQL database (blogs) that has a id, title, timestamp, and category_id column names. How can I select one row from each category that has the newest timestamp? If I have 3 rows being in category 1, 2, 1, then I will get two rows back with the highest timestamp of the categories in "1" as the first and the row with category "2" as the second.I have a MySQL database (blogs) that has a id,




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: