5-in-subquery.sql

SQL Server 2005基础教程一书的源代码.

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))