如何在下面的查询中找出最大日期 [英] how to find out maximum date in below query

问题描述

PLZ帮帮我....如何在下面的查询中找出最大日期（加粗字体）........................... ..



SELECT客户。*，

CProfit.Pdate， CProfit.Pbalance，

Deposit.Ddate ，Deposit.AmountDeposit，

LPB.Ddate，LPB.Balance，

Loan.Ddate，Loan.LoanAmount ，

LoanPaid.Ddate， LoanPaid.PaidAmount，

OPB.Ddate，OPB.Balance，

提款。日期，取款。取消从OPB INNER JOIN取消

（存入内部加入（贷款内部加入）（LPB内部加入（LoanPaid内部加入）（CProfit INNER JOIN

（撤回INNER JOIN客户开启

提款.CID = Customers.CID）ON

CProfit.CID = Customers.CID）ON

LoanPaid.CID = Customers.CID）ON

LPB.CID = Customers.CID）ON

Loan.CID = Customers.CID）ON

Deposit.CID = Customers.CID）ON

OPB.CID = Customers.CID

ORDER BY Customers.CID

解决方案

您正在选择DDate三次。您需要使用''as'来命名它们：

  SELECT  Customers。*，
 CProfit.Pdate，CProfit.Pbalance，
 Deposit.Ddate，Deposit.AmountDeposit，
 LPB.Ddate  as  LPBDate，LPB.Balance，
 Loan.Ddate  as  LoanDate，Loan.LoanAmount，
 LoanPaid.Ddate，LoanPaid.PaidAmount，
 OPB.Ddate  as  OPBDate，OPB.Balance，
 Withdrawal.Ddate，Withdrawal.WithdrawalAmount FROM OPB INNER JOIN 
（存入INNER JOIN（贷款INNER JOIN（LPB INNER JOIN（LoanPaid INNER JOIN）（CProfit INNER JOIN 
（提取INNER JOIN客户 ON  
提款.CID = Customers.CID ） ON  
 CProfit.CID = Customers.CID） ON  
 LoanPaid.CID = Customers.CID） ON  
 LPB.CID = Customers.CID） ON  
 Loan.CID = Customers.CID） ON  
 Deposit.CID = Customers.CID） ON  
 OPB.CID = Customers.CID 
 ORDER BY Customers.CID 

对于你的问题：

  SELECT  max（LPB.Ddate） - 假设这个 你想要的那个
来自OPB INNER JOIN 
（存款INNER JOIN（贷款INNER JOIN）（LPB INNER JOIN（LoanPaid INNER） JOIN（CProfit INNER JOIN 
（取款INNER JOIN客户 ON  
 Withdrawal.CID = Customers.CID） ON  
 CProfit.CID = Customers.CID） ON  
 LoanPaid.CID = Customers.CID） ON  
 LPB.CID = Customers.CID） ON  
 Loan.CID = Customers.CID）< span class =code-keyword> ON  
 Deposit.CID = Customers.CID） ON  
 OPB.CID = Customers.CID 

你也可以这样做：

 选择 max（LoanDate）
来自
（
  SELECT  Customers。*，
 CProfit.Pdate，CProfit.Pbalance，
 Deposit.Ddate，Deposit.AmountDeposit， 
 LPB.Ddate  as  LPBDate，LPB.Balance，
 Loan.Ddate  as  LoanDate，Loan.LoanAmount，
 LoanPaid.Ddate  as  LoanPaidDate，LoanPaid.PaidAmount，
 OPB.Ddate，OPB.Balance，
提款.Ddate，Withdrawal.WithdrawalAmount FROM OPB INNER JOIN 
（存入INNER JOIN（贷款INNER JOIN）（LPB INNER JOIN（LoanPaid INNER JOIN）（CProfit INNER JOIN 
（提取内部联合客户 ON  
 Withdrawal.CID = Customers.CID） ON  
 CProfit.CID = Customers.CID） ON  
 LoanPaid.CID = Customers.CID） ON  
 LPB.CID = Customers.CID） ON  
 Loan.CID = Customers.CID） ON  
 Deposit.CID = Customers.CID ） ON  
 OPB.CID = Customers.CID 
 ORDER BY Customers.CID 
）

plz help me ....how to find out maximum date(bold font) in below query .............................

SELECT Customers.*,
CProfit.Pdate, CProfit.Pbalance,
Deposit.Ddate, Deposit.AmountDeposit,
LPB.Ddate, LPB.Balance,
Loan.Ddate, Loan.LoanAmount,
LoanPaid.Ddate, LoanPaid.PaidAmount,
OPB.Ddate,OPB.Balance,
Withdrawal.Ddate, Withdrawal.WithdrawalAmount FROM OPB INNER JOIN
(Deposit INNER JOIN (Loan INNER JOIN (LPB INNER JOIN (LoanPaid INNER JOIN (CProfit INNER JOIN
(Withdrawal INNER JOIN Customers ON
Withdrawal.CID=Customers.CID) ON
CProfit.CID=Customers.CID) ON
LoanPaid.CID=Customers.CID) ON
LPB.CID=Customers.CID) ON
Loan.CID=Customers.CID) ON
Deposit.CID=Customers.CID) ON
OPB.CID=Customers.CID
ORDER BY Customers.CID

解决方案

You are selecting DDate three times. You need to use ''as'' to name them:

SELECT Customers.*,
CProfit.Pdate, CProfit.Pbalance,
Deposit.Ddate, Deposit.AmountDeposit,
LPB.Ddate as LPBDate, LPB.Balance,
Loan.Ddate as LoanDate, Loan.LoanAmount,
LoanPaid.Ddate, LoanPaid.PaidAmount,
OPB.Ddate as OPBDate,OPB.Balance,
Withdrawal.Ddate, Withdrawal.WithdrawalAmount FROM OPB INNER JOIN
(Deposit INNER JOIN (Loan INNER JOIN (LPB INNER JOIN (LoanPaid INNER JOIN (CProfit INNER JOIN
(Withdrawal INNER JOIN Customers ON
Withdrawal.CID=Customers.CID) ON
CProfit.CID=Customers.CID) ON
LoanPaid.CID=Customers.CID) ON
LPB.CID=Customers.CID) ON
Loan.CID=Customers.CID) ON
Deposit.CID=Customers.CID) ON
OPB.CID=Customers.CID
ORDER BY Customers.CID

For your question:

SELECT max(LPB.Ddate) -- assuming this is the one you want
FROM OPB INNER JOIN
(Deposit INNER JOIN (Loan INNER JOIN (LPB INNER JOIN (LoanPaid INNER JOIN (CProfit INNER JOIN
(Withdrawal INNER JOIN Customers ON
Withdrawal.CID=Customers.CID) ON
CProfit.CID=Customers.CID) ON
LoanPaid.CID=Customers.CID) ON
LPB.CID=Customers.CID) ON
Loan.CID=Customers.CID) ON
Deposit.CID=Customers.CID) ON
OPB.CID=Customers.CID

you could also do this:

select max(LoanDate)
from
(
SELECT Customers.*,
CProfit.Pdate, CProfit.Pbalance,
Deposit.Ddate, Deposit.AmountDeposit,
LPB.Ddate as LPBDate, LPB.Balance,
Loan.Ddate as LoanDate, Loan.LoanAmount,
LoanPaid.Ddate as LoanPaidDate, LoanPaid.PaidAmount,
OPB.Ddate,OPB.Balance,
Withdrawal.Ddate, Withdrawal.WithdrawalAmount FROM OPB INNER JOIN
(Deposit INNER JOIN (Loan INNER JOIN (LPB INNER JOIN (LoanPaid INNER JOIN (CProfit INNER JOIN
(Withdrawal INNER JOIN Customers ON
Withdrawal.CID=Customers.CID) ON
CProfit.CID=Customers.CID) ON
LoanPaid.CID=Customers.CID) ON
LPB.CID=Customers.CID) ON
Loan.CID=Customers.CID) ON
Deposit.CID=Customers.CID) ON
OPB.CID=Customers.CID
ORDER BY Customers.CID
)

这篇关于如何在下面的查询中找出最大日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！