一表结构
create table bbsCardInfo
(
bbsCaptionId varchar2(15), --bbs版块标题id
bbsNameId varchar2(15), --REFERENCES bbsInfo(bbsNameId), --外键,bbs版块id
roleId varchar2(15), --REFERENCES bbsUserRoleInfo(roleId), --外键,用户帐号id
cardId varchar2(15) primary key, --帖子id
cardTopic varchar2(50), --帖子主题
cardText varchar2(1000), --帖子内容
cardPicId varchar2(100), --帖子图片
cardVideo varchar2(500), --帖子视频
cardTime date default(sysdate), --帖子发表时间
cardEditTime date default(sysdate), --帖子最后编辑时间
cardState varchar2(5) default(0), --帖子状态,0为草稿帖,1为普通帖,2为推荐帖,3为精华置顶帖
re varchar2(255) --备注
)tablespace USERS; 表中数据:
<ROW>
<C0>1</C0>
<BBSCAPTIONID>C001</BBSCAPTIONID>
<BBSNAMEID>BN001</BBSNAMEID>
<ROLEID>10001</ROLEID>
<CARDID>10001</CARDID>
<CARDTOPIC>jay2009新专辑</CARDTOPIC>
<CARDTEXT>期待啊....</CARDTEXT>
<CARDTIME>2009-7-6 16:05:58</CARDTIME>
<CARDEDITTIME>2009-7-6 16:05:58</CARDEDITTIME>
</ROW><ROW>
<C0>2</C0>
<BBSCAPTIONID>C001</BBSCAPTIONID>
<BBSNAMEID>BN002</BBSNAMEID>
<ROLEID>10001</ROLEID>
<CARDID>10002</CARDID>
<CARDTOPIC>jay新PP</CARDTOPIC>
<CARDTEXT>好帅哦....</CARDTEXT>
<CARDTIME>2009-7-6 16:18:43</CARDTIME>
<CARDEDITTIME>2009-7-6 16:18:43</CARDEDITTIME>
</ROW><ROW>
<C0>3</C0>
<BBSCAPTIONID>C001</BBSCAPTIONID>
<BBSNAMEID>BN003</BBSNAMEID>
<ROLEID>10001</ROLEID>
<CARDID>10003</CARDID>
<CARDTOPIC>jay-<不能说的秘密>在线看</CARDTOPIC>
<CARDTEXT>好看额....</CARDTEXT>
<CARDTIME>2009-7-6 16:18:44</CARDTIME>
<CARDEDITTIME>2009-7-6 16:18:44</CARDEDITTIME>
</ROW><ROW>
<C0>4</C0>
<BBSCAPTIONID>C002</BBSCAPTIONID>
<BBSNAMEID>BN004</BBSNAMEID>
<ROLEID>10002</ROLEID>
<CARDID>10004</CARDID>
<CARDTOPIC>你最喜欢jay的哪句歌词</CARDTOPIC>
<CARDTEXT>我会学着放弃你,是因为我太爱你....</CARDTEXT>
<CARDTIME>2009-7-6 16:18:44</CARDTIME>
<CARDEDITTIME>2009-7-6 16:18:44</CARDEDITTIME>
</ROW><ROW>
<C0>5</C0>
<BBSCAPTIONID>C003</BBSCAPTIONID>
<BBSNAMEID>BN009</BBSNAMEID>
<ROLEID>10002</ROLEID>
<CARDID>10005</CARDID>
<CARDTOPIC>申请当版主</CARDTOPIC>
<CARDTEXT>加精....</CARDTEXT>
<CARDTIME>2009-7-6 16:18:44</CARDTIME>
<CARDEDITTIME>2009-7-6 16:18:44</CARDEDITTIME>
</ROW><ROW>
<C0>6</C0>
<BBSCAPTIONID>C001</BBSCAPTIONID>
<BBSNAMEID>BN002</BBSNAMEID>
<ROLEID>10001</ROLEID>
<CARDID>10006</CARDID>
<CARDTOPIC>jay新壁纸</CARDTOPIC>
<CARDTEXT>好帅哦....</CARDTEXT>
<CARDTIME>2009-7-4 16:35:06</CARDTIME>
<CARDEDITTIME>2009-7-4 16:35:06</CARDEDITTIME>
</ROW>版块id:BN002有两个帖子select bbsCaptionId,bbsNameId,cardTopic,min(to_char(cardTime,'yyyy-mm-dd hh24:mi:ss')) from bbsCardInfo group by bbsCaptionId,bbsNameId,cardTopic;我要查各版块最后发帖的时间,发帖人和主题,BN002总是有重复的·很头疼不知道怎么解决了,加了distinct也没用
这个cardTopic一加之后就有重复数据了,不加上则没,求高手解决!
create table bbsCardInfo
(
bbsCaptionId varchar2(15), --bbs版块标题id
bbsNameId varchar2(15), --REFERENCES bbsInfo(bbsNameId), --外键,bbs版块id
roleId varchar2(15), --REFERENCES bbsUserRoleInfo(roleId), --外键,用户帐号id
cardId varchar2(15) primary key, --帖子id
cardTopic varchar2(50), --帖子主题
cardText varchar2(1000), --帖子内容
cardPicId varchar2(100), --帖子图片
cardVideo varchar2(500), --帖子视频
cardTime date default(sysdate), --帖子发表时间
cardEditTime date default(sysdate), --帖子最后编辑时间
cardState varchar2(5) default(0), --帖子状态,0为草稿帖,1为普通帖,2为推荐帖,3为精华置顶帖
re varchar2(255) --备注
)tablespace USERS; 表中数据:
<ROW>
<C0>1</C0>
<BBSCAPTIONID>C001</BBSCAPTIONID>
<BBSNAMEID>BN001</BBSNAMEID>
<ROLEID>10001</ROLEID>
<CARDID>10001</CARDID>
<CARDTOPIC>jay2009新专辑</CARDTOPIC>
<CARDTEXT>期待啊....</CARDTEXT>
<CARDTIME>2009-7-6 16:05:58</CARDTIME>
<CARDEDITTIME>2009-7-6 16:05:58</CARDEDITTIME>
</ROW><ROW>
<C0>2</C0>
<BBSCAPTIONID>C001</BBSCAPTIONID>
<BBSNAMEID>BN002</BBSNAMEID>
<ROLEID>10001</ROLEID>
<CARDID>10002</CARDID>
<CARDTOPIC>jay新PP</CARDTOPIC>
<CARDTEXT>好帅哦....</CARDTEXT>
<CARDTIME>2009-7-6 16:18:43</CARDTIME>
<CARDEDITTIME>2009-7-6 16:18:43</CARDEDITTIME>
</ROW><ROW>
<C0>3</C0>
<BBSCAPTIONID>C001</BBSCAPTIONID>
<BBSNAMEID>BN003</BBSNAMEID>
<ROLEID>10001</ROLEID>
<CARDID>10003</CARDID>
<CARDTOPIC>jay-<不能说的秘密>在线看</CARDTOPIC>
<CARDTEXT>好看额....</CARDTEXT>
<CARDTIME>2009-7-6 16:18:44</CARDTIME>
<CARDEDITTIME>2009-7-6 16:18:44</CARDEDITTIME>
</ROW><ROW>
<C0>4</C0>
<BBSCAPTIONID>C002</BBSCAPTIONID>
<BBSNAMEID>BN004</BBSNAMEID>
<ROLEID>10002</ROLEID>
<CARDID>10004</CARDID>
<CARDTOPIC>你最喜欢jay的哪句歌词</CARDTOPIC>
<CARDTEXT>我会学着放弃你,是因为我太爱你....</CARDTEXT>
<CARDTIME>2009-7-6 16:18:44</CARDTIME>
<CARDEDITTIME>2009-7-6 16:18:44</CARDEDITTIME>
</ROW><ROW>
<C0>5</C0>
<BBSCAPTIONID>C003</BBSCAPTIONID>
<BBSNAMEID>BN009</BBSNAMEID>
<ROLEID>10002</ROLEID>
<CARDID>10005</CARDID>
<CARDTOPIC>申请当版主</CARDTOPIC>
<CARDTEXT>加精....</CARDTEXT>
<CARDTIME>2009-7-6 16:18:44</CARDTIME>
<CARDEDITTIME>2009-7-6 16:18:44</CARDEDITTIME>
</ROW><ROW>
<C0>6</C0>
<BBSCAPTIONID>C001</BBSCAPTIONID>
<BBSNAMEID>BN002</BBSNAMEID>
<ROLEID>10001</ROLEID>
<CARDID>10006</CARDID>
<CARDTOPIC>jay新壁纸</CARDTOPIC>
<CARDTEXT>好帅哦....</CARDTEXT>
<CARDTIME>2009-7-4 16:35:06</CARDTIME>
<CARDEDITTIME>2009-7-4 16:35:06</CARDEDITTIME>
</ROW>版块id:BN002有两个帖子select bbsCaptionId,bbsNameId,cardTopic,min(to_char(cardTime,'yyyy-mm-dd hh24:mi:ss')) from bbsCardInfo group by bbsCaptionId,bbsNameId,cardTopic;我要查各版块最后发帖的时间,发帖人和主题,BN002总是有重复的·很头疼不知道怎么解决了,加了distinct也没用
这个cardTopic一加之后就有重复数据了,不加上则没,求高手解决!
你简化一些吗?这样我们怎么看呢?