如何最优写这条SQL语句(附表结构)

[RuimeiSoft]

第一个表Product表,字段有:ProductId ProductName ReleaseData
第二表ProductSKU表,字段有:ProductId SKU ReleaseDate
他们是一对多的关系
即一个Product可以有多个SKU,但至少有一个

现在要解决的问题是:
提取最新的10条含有至少2个SKU的Product信息
请问如何写这个SQL语句?

[syeerzy]

SELECT TOP 10 ProductId ,ProductName ,ReleaseData
FROM Product
WHERE ProductId IN
(
SELECT DISTINCT ProductId
FROM ProductSKU
GROUP BY ProductId
HAVING Count(SKU) > 1
)
ORDER BY ReleaseData DESC

[spz1755]

是SQL Server还是Oracle？

[RuimeiSoft]

SQL Server

[RuimeiSoft]

ding

[spz1755]

想不出来，帮你顶吧

[李洪喜]

select top 10 ProductId ,max( ReleaseDate) as dt ProductSKU
group by ProductId
having count(*)>=3
order by ReleaseDate

大体上是这样吧。
试一试吧。

[xyy2]

select ProductId ,ProductName ,ReleaseData from Product
where ProductId in (
select ProductId from ProductSKU
group by ProductId
having count(SKU) >= 2
)

[xyy2]

select top 10 ProductId ,ProductName ,ReleaseData from Product
where ProductId in (
select ProductId from ProductSKU
group by ProductId
having count(SKU) >= 2
)
order by ReleaseData desc

[JasonHeung]

xyy2(爱) ( ) 信誉：100 2005-07-08 11:52:00 得分: 0


select top 10 ProductId ,ProductName ,ReleaseData from Product
where ProductId in (
select ProductId from ProductSKU
group by ProductId
having count(SKU) >= 2
)
order by ReleaseData desc

[RuimeiSoft]

排序方式我要根据ProductSKU表的ReleaseData

[RuimeiSoft]

定