Monday, April 30, 2007

TSQL 2005 - ALL

SQL Function to evaluate results of a subquery >
IF 130 > ALL (SELECT Rate FROM HumanResources.EmployeePayHistory)
 PRINT 'No employee is paid more than 130.'
ELSE
 PRINT 'There are employees paid more than 130.'

No comments: