谁能帮忙把这个SQL优化一下?其实意思很简单的,但是我不太会这个。
SELECT t4.IDS, t4.STATE, t4.FIXTIME, t4.PSIP, t4.RD_DOMAIN, t4.RD_PATH, t4.S_DOMAIN, t4.S_P1, t4.S_P2, t4.S_P3, t4.S_P4, t4.S_P5, t4.S_P6, t4.S_P7, t4.S_P8
FROM (SELECT TOP 10 S_DOMAIN
FROM (SELECT TOP 50 S_DOMAIN
FROM (SELECT DISTINCT S_DOMAIN
FROM dbo.ProxyUrl) AS t1
ORDER BY S_DOMAIN) AS t2
ORDER BY S_DOMAIN DESC) AS t3 INNER JOIN
dbo.ProxyUrl AS t4 ON t3.S_DOMAIN = t4.S_DOMAIN