取出日期这个字段的最大日期的前10条记录

[yzaiml]

SELECT financial.effDate,financial.appDate,price.fundName,
price.bidPrice, price.offerPrice, financial.unitNum ,financial.accUnitNum * price.offerPrice AS InvestPrice
FROM financial INNER JOIN price ON financial.fundId = price.fundId
WHERE (financial.contractNo = 'BB00001001') and (price.transCode='00' )

这是现在的sql
我要取出 financial.effDate 这个字段前10条 日期最大的记录

[青锋-SS]

select top 10 financial.effDate from
(SELECT financial.effDate,financial.appDate,price.fundName,
price.bidPrice, price.offerPrice, financial.unitNum ,financial.accUnitNum * price.offerPrice AS InvestPrice
FROM financial INNER JOIN price ON financial.fundId = price.fundId
WHERE (financial.contractNo = 'BB00001001') and (price.transCode='00' )) t
order by financial.effDate desc

[青锋-SS]

select top 10 effDate from
(SELECT financial.effDate,financial.appDate,price.fundName,
price.bidPrice, price.offerPrice, financial.unitNum ,financial.accUnitNum * price.offerPrice AS InvestPrice
FROM financial INNER JOIN price ON financial.fundId = price.fundId
WHERE (financial.contractNo = 'BB00001001') and (price.transCode='00' )) t
order by effDate desc

[yzaiml]

服务器: 消息 107，级别 16，状态 3，行 1
列前缀 'financial' 与查询中所用的表名或别名不匹配。

[leo_lesley]

SELECT top 10 financial.effDate,financial.appDate,price.fundName,
price.bidPrice, price.offerPrice, financial.unitNum ,financial.accUnitNum * price.offerPrice AS InvestPrice
FROM financial INNER JOIN price ON financial.fundId = price.fundId
WHERE (financial.contractNo = 'BB00001001') and (price.transCode='00' )
order by financial.effDate desc

[Limpire]

SELECT TOP 10 financial.effDate,financial.appDate,price.fundName,
price.bidPrice, price.offerPrice, financial.unitNum ,financial.accUnitNum * price.offerPrice AS InvestPrice
FROM financial INNER JOIN price ON financial.fundId = price.fundId
WHERE (financial.contractNo = 'BB00001001') and (price.transCode='00' )
ORDER BY financial.effDate DESC