Dustin Waybright highlighted SELECT productid, productname, unitpri...

Skip to content

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

4. Combining Sets
from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
by Dejan Sarka Itzik Ben-Gan and Ron Talmage
Publisher: Microsoft Press
Released: December 2012

Note

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

Share this highlight

http://www.safaribooksonline.com/a/training-kit-exam/24095/