我想在论坛页面中找到最后一位作家 [英] I want to find last writer in my forum page

问题描述

我有2个表，它们的名称是PersonelForumKonuBaslik(PersonelForumSubjectTitle)和PersonelForumCevap(PersonelForumAnswer)

I have 2 tables.Their names are PersonelForumKonuBaslik(PersonelForumSubjectTitle) and PersonelForumCevap(PersonelForumAnswer)

PersonelForumCevap(PersonelForumAnswer)
PersonelForumId 	                                int	
PersonelForumCevapId(PersonelForumAnswerId)Primarykey   int                                
PersonelForumCevapYanit(PersonelForumTitleAnswer)	nvarchar(500)	
PersonelForumSonCevapYazan(PersonelForumLastWriter)	nvarchar(50)	

88 14本索克·苏祖尔姆·梅尔夫
87 15 Bence iyi birisi merve
87 16本塞德·伯克
88 17本德·卡蒂尔·约鲁姆·萨纳·伯克

我的存储过程是

88 14 Ben çok üzüldüm merve
87 15 Bence iyi birisi merve
87 16 bencede berke
88 17 bende katılıyorum sana berke

my stored procedure is,

select  A.PersonelForumId,
PersonelForumKonuBaslik,
PersonelForumBaslatan,
B.PersonelForumSonCevapYazan,
from PersonelForumKonuBaslik as A 
inner join PersonelForumCevap as B 
on B.PersonelForumId=A.PersonelForumId

结果
ForumId PersonelForumTitle PersonelForumTitleStartWriter PersonelForumTitleAnswer
88 RecaiHocanıngidişihamit merve
87 Hulya Hocahakkkındaahmet merve
87 Hulya Hocahakkkındaahmet berke
88 RecaiHocanıngidişihamit berke

我想在网页表单页面中最后一位作家.我想要这个结果该怎么办?

ForumId PersonelForumTitle PersonelForumTitleStartWriter PersonelForumTitleAnswer
88 RecaiHocanıngidişihamit merve
87 Hulya Hocahakkkındaahmet berke

This result
forumId PersonelForumTitle PersonelForumTitleStartWriter PersonelForumTitleAnswer
88 Recai Hocanın gidişi hamit merve
87 Hulya Hoca hakkkında ahmet merve
87 Hulya Hoca hakkkında ahmet berke
88 Recai Hocanın gidişi hamit berke

I want to last writer in webform page. i want to this result how can i do that?

forumId PersonelForumTitle PersonelForumTitleStartWriter PersonelForumTitleAnswer
88 Recai Hocanın gidişi hamit merve
87 Hulya Hoca hakkkında ahmet berke

推荐答案

我要在PersonelForumCevap表中添加一个DateTime列，以保存答案发布的日期和时间，并在存储中使用SORT返回最新的程序.其他一切都取决于数据库内部.

I would add a DateTime column to the PersonelForumCevap table to hold the date and time the answer was posted, and use SORT in the stored procedure to return the latest. Anything else relies on the database internals.

这篇关于我想在论坛页面中找到最后一位作家的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！