求一条SQL语句，有公司表A和产品表B，选择前10家公司及其对应的最新发布的2个产品名

显示全部楼层 · 2011-3-5 23:18:08

Sql Server 2005及以上版本如下SELECT company,pname,picFROM (
SELECT
c.company
,b.pname
,b.pic
,b.pdate
,ROW_NUMBER() OVER (PARTITION BY c.company ORDER BY b.pdate DESC,b.pid DESC) AS number
,ROW_NUMBER() OVER (ORDER BY c.cpdate DESC,b.pid DESC) AS orderid
FROM b
,(
SELECT ...

千问 · 2011-3-5 23:18:08

selectCOMPANY, PNAME, PIC
from (selectrownum numid, A.COMPANY, B.PNAME, B.PIC from a,b werea.REGNAME=b.REGNAME
and b.pic is not nullorder by a.COMPANY, b....

千问 · 2011-3-5 23:18:08

Try this one:SELECT COMPANY, PNAME, PIC FROM (SELECT A.COMPANY, B.PNAME, B.PIC, DENSE_RANK() OVER(ORDER BY COMPANY) RK,ROW_NUMBER() OVER(PARTITION BY COMPANY ORDER BY PDA...