5-in-subquery.sql

来自「SQL Server 2005基础教程一书的源代码.」· SQL 代码 · 共 9 行

SELECT *
  FROM ShareDetails.Shares
 WHERE ShareId IN (SELECT ShareId 
                     FROM ShareDetails.Shares
                    WHERE CurrentPrice > (SELECT MIN(CurrentPrice)
                                            FROM ShareDetails.Shares)
                      AND CurrentPrice < (SELECT MAX(CurrentPrice)
                                            FROM ShareDetails.Shares))