Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Thursday, December 7, 2017

DISTINCT FOR ONE COLUMN ONLY

SQLServerCentral » Latest topics
DISTINCT FOR ONE COLUMN ONLY
Guys,  how do i make the following only bring back one value for each REGNO? As you can see some of then are bring back 2 in the total column?  Select Distinct shows the same results.

Many thanks

No comments: