Perennial problem which you would imagine would be easy to do, but always seems to cause confusion.
Look at the table below, we want to Select Distinct Single Item then any item from other columns in MS SQL 2012
So for example here we want just take one V9E row, not both. Similary for the B1N row.
The SQL 2012 command for this gleaned from the for MS-SQL answer on http://dba.stackexchange.com/questions/24327/how-to-select-distinct-for-one-column-and-any-in-another-column
© 2004 - 2021 1 Oak Hill Grove Surbiton Surrey KT6 6DS Phone: +44(020) 8123 1321