sql语句:
Select Max(Id) As Id ,Title,(Select FieldC From TableC Where AId= 这里怎么取外搜索 的Max(Id)值 ) From tableA A Inner Join TableB B On B.Id=A.BId Where B.FieldsA='xxx' Group By A.Title
Select Max(Id) As Id ,Title,(Select FieldC From TableC Where AId= 这里怎么取外搜索 的Max(Id)值 ) From tableA A Inner Join TableB B On B.Id=A.BId Where B.FieldsA='xxx' Group By A.Title
解决方案 »
- 请教一条非常简单的sql语句性能问题。。
- mysql_fetch_array 问题
- case when 问题
- 游标使用,得不多数据,晕死了
- 用distinct或group by能解决这个问题吗?急!
- 用存储过程怎么返回值啊?
- 收藏 不显示删除回复显示所有回复显示星级回复显示得分回复 附加数据库遇到:CREATE FILE encountered operating system er
- 登录不了SQL Server2000企业管理器
- 你们是如何处理的?
- vb与sql的问题(触发器,存储过程)
- 存储过程 平行的2个IF ELSE 语句 只执行了一个
- with drop_existing 重建了聚集索引后,还需要手动重建每一个非聚集索引吗?
SELECT a.id,a.Title,c.FieldC FROM (
Select Max(Id) As Id ,Title
From tableA A
Inner Join TableB B On B.Id=A.BId
Where B.FieldsA='xxx'
Group By A.Title
) a
INNER JOIN TableC AS c ON a.id=c.Aid也不知道是不是这个意思啊
(Select FieldC From TableC Where AId= Max(A.Id) ) -- 直接写就行了,把外部表名(或别名)写上
From tableA A
Inner Join TableB B On B.Id=A.BId
Where B.FieldsA='xxx'
Group By A.Title
T.Title,
C.FieldC
FROM (
SELECT MAX(Id) AS Id,
Title
FROM tableA A
INNER JOIN TableB B
ON B.Id = A.BId
WHERE B.FieldsA = 'xxx'
GROUP BY
A.Title
) AS T
INNER JOIN TableC AS C
ON C.AId = T.Id
Select
H.id,
H.Title,
T. FieldC
From TableC T
Inner Join(
Select Max(Id) As Id ,
Title
From tableA A
Inner Join TableB B On B.Id=A.BId
Where B.FieldsA='xxx' Group By A.Title
)H on T.AId= H. Id
Select Max(Id) As Id ,Title,(Select FieldC From TableC Where AId= Max(Id) ) From tableA A Inner Join TableB B On B.Id=A.BId Where B.FieldsA='xxx' Group By A.Title