SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 2 | Journey to SQL Authority with Pinal Dave

Please read SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL before continuing this article. I had asked users to come up with alternate solution of the same problem. Let us see following example provided by Khadar Khan. This example is using newly introduced concept of CTE of SQL Server 2005.… Continue Reading...

Source: SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 2 | Journey to SQL Authority with Pinal Dave