请问这个SQL语句该怎么改？(100分)

X

xmusyh

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #1

SQL语句如下：
select *
from XTable
where (a,b,c,ReleaseDate)in
(select distinct a,b,c,max(ReleaseDate) as ReleaseDate
from XTable
group by a,b,c
)
但是这个SQL语句不正确，请问该怎么改呢？

 

Y

y_sm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #2

select a.*
from XTable a, (
select a,b,c,max(ReleaseDate) ReleaseDate
from XTable
group by a,b,c
) b
where a.a=b.a
and a.b=b.b
and a.c=b.c
and a.ReleaseDate=b.ReleaseDate

 

B

bes96261

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #3

從你的語句意理解看，應可改成：
select * from XTable as V
where ReleaseDate=( select Max(ReleaseDate) from XTable where a=V.a and b=V.b)

 

B

bes96261

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #4

剛才少寫了個and c=V.c
select * from XTable as V
where ReleaseDate=( select Max(ReleaseDate) from XTable where a=V.a and b=V.b and c=V.c)

 

C

cyf_00002

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #5

max 用的不对吧
你最好还是换一中方法吧，好象单纯的SQL解决不了问题
如果你解决了，请告诉我
反正我看是不行

 

B

bes96261

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #6

樓主的意思應該很簡單了：在表XTable中存在四個字段a b c ReleaseDate
想查詢出 a b c 三個字段內容相同的最近一次ReleaseDate時間了，怎麼會辦不到呢?

 

X

xmusyh

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #7

接受答案了.