Group by and non distinct columns and data normalization <p>I have a large table(60 columns, 1.5 million records) of denormalized data in MS SQL 2005 that was imported from an Access database. I've been tasked with normalizing and inserting this data into our data model. </p> <p>I would like to create a query that used a grouping of, for example "customer_number", and returned a result set that only contains the columns that are non distinct for each customer_number. I don't know if it's even possible, but it would be of great help if it was.</p> <p>Edit:if my table has 3 columns(cust_num,cust_name_cust_address) and 5 records</p> <pre><code>|cust_num|cust_name|cust_address |01 |abc |12 1st street |02 |cbs |1 Aroundthe Way |01 |abc |MLK BLVD |03 |DMC |Hollis Queens |02 |cbs |1 Aroundthe Way </code></pre> <p>the results from my desired query should just be the data from cust_num and cust_name because cust_address has different values for that grouping of cust_num. A cust_num has many addresses but only one cust_name.</p> <p>Can someone point me in the right direction? </p> <p>Jim</p>