Itzik Ben-gan T-sql Fundamentals =link=

SELECT * FROM (SELECT empid, YEAR(orderdate) AS orderyear FROM orders) AS o WHERE o.orderyear = 2020;

The book is structured to take a reader from a complete novice to a proficient practitioner capable of writing robust, efficient code. Key topics include: Go to product viewer dialog for this item. T-SQL Fundamentals itzik ben-gan t-sql fundamentals