我有一张包含驴，候选人，发送者，状态的表。所以我想根据贱民，候选人和订单更新状态。怎么可能？请任何人...... [英] I Have A Table Which Contain Companyid,Candidateid,Sendingdate,Status. So I Want To Update Status On The Basis Of Companyid,Candidateid And Order By Sendingdate. How Its Possible? Please Anyone...

问题描述

我有一张包含CompanyId，CandidateId，SendingDate，Status的表格。

所以我想根据Companyid，CandidateId和SendingDate的订单更新状态。

怎么可能呢？

请有人对此有什么看法吗？

解决方案

从这里学习并适应 example [ ^ ]

您的问题有点不清楚，但假设您的数据库是MSSQL，这样的事情可能会起作用：

  UPDATE  targetTable 
  SET  Status = ' 新状态值 
  WHERE  Comp anyid = ' 您的公司ID' 
  AND  CandidateId = ' 您的候选人ID'; 
 
  SELECT  CompanyId，CandidateId，SendingDate，Status 
  FROM  targetTable 
  ORDER   BY  SendingDate; 
 

希望它有所帮助。

看到这个示例 [ ^ ]

;   cte  as （
 选择 Dtid，dt，Row_number（） over （ order   by  Dt） as  rn 来自 test 
）
  update  cte < span class =code-keyword> set  DTid = rn; 

你也可以更新你的表格

i have a table which contain CompanyId,CandidateId,SendingDate,Status.
So i want to update Status on the basis of Companyid,CandidateId And Order by SendingDate.
how its possible?
please anyone have any about this?

解决方案

Learn and adapt from this example[^]

Your question is a little unclear, but assuming your database is MSSQL, something like this might work:

UPDATE targetTable
SET Status = 'New Status Value'
WHERE  Companyid = 'Your Company ID'
AND CandidateId = 'Your Candidate ID';

SELECT CompanyId,CandidateId,SendingDate,Status
FROM targetTable
ORDER BY SendingDate;

Hope it helps.

see this example [^]

;with cte as(
  select Dtid, dt, Row_number() over (order by Dt) as rn from test
  )
update cte set DTid =rn;

like wise you can update your table too

这篇关于我有一张包含驴，候选人，发送者，状态的表。所以我想根据贱民，候选人和订单更新状态。怎么可能？请任何人......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！