O'Reilly logo
  • Dustin Waybright thinks this is interesting:

SELECT productid, productname, unitprice FROM Production.Products WHERE unitprice = (SELECT MIN(unitprice) FROM Production.Products);

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

Using a single-value subquery as a WHERE predicate example.