S&M NuTec, the company that produces Greenies, furnished us a copy of the complete statement they sent to KIRO-TV, which touches on some of the cases discussed: Our Commitment to Healthy Pets Our company was founded and is staffed by people who are deeply passionate about pets and their welfare.
This SQL Server tutorial explains how to use the LEAD function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the LEAD function is an analytic function that lets you query more than one row in a table at a time without having to join the table to itself.
Specifically, the query applies the UPPER function to the LAST_NAME column of the EMPLOYEE table for certain employees. The UPPER function is said to be nested inside the INITCAP function. The Oracle Database server applies nested functions in order, from innermost function to outermost function.