DISTINCT问题

az2k 2004-11-26 10:35:32

在一个查询多个表和列的语句中，怎么用DISTINCT？
select nOrderId,sClientName,sPrjName,nPreContractFinance,sRecvAddress,sReceiverName,dtOrderDate,tNodes.sName as nodename,tMessageStatus.sName as MsgName from tOrderi,tNodeAccessUserConfig,tNodes,tMessageStatus where tNodeAccessUserConfig.nOrigNodeId=tOrderi.nOrigiatedNodeId and tNodeAccessUserConfig.sUserName='"&sname&"' and tOrderi.nstatusId=tMessageStatus.nId order by dtOrderDate desc

...全文

84 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

good2speed 2004-11-26

打赏
举报

select nOrderId,sClientName,sPrjName,nPreContractFinance,sRecvAddress,sReceiverName,dtOrderDate,tNodes.sName as nodename,tMessageStatus.sName as MsgName from tOrderi,tNodeAccessUserConfig,tNodes,tMessageStatus where tNodeAccessUserConfig.nOrigNodeId=tOrderi.nOrigiatedNodeId and tNodeAccessUserConfig.sUserName='"&sname&"' and tOrderi.nstatusId=tMessageStatus.nId
GROUP BY nOrderId,sClientName,sPrjName,nPreContractFinance,sRecvAddress,sReceiverName,dtOrderDate,tNodes.sName,tMessageStatus.sName
order by dtOrderDate desc

变量定义，字段约束、等等，Select 、Where、Top、Group By 、Order By，Distinct、Declare等，详细可看图片和课程，本课程带有完整的SQL数据库课程课件，代码有注释解析等等，学习起来简单易懂，易上手直接操作，...

distinct if > versioncode as code < include refid = " Base_Column_List " /> from odpsrequesttoidbtable < if test = " _parameter != null " > < include refid = " Param_Where_...

问题描述因为要设计一个数据库表，进行一个倒序去重的操作。例如：idName1B2A3A4C5C6B场景：例如说我们需要得到一个用户的搜索记录，那么肯定不会仅仅根据时间倒序排序给出列表展示，因为这样会出现重复的问题。我们...