<div>
obviously col3 is a date field. &nbsp;What are you trying to group on? the month? year? &nbsp;Otherwise i don't see the problem with the data.
</div>


obviously col3 is a date field.  What are you trying to group on? the month? year?  Otherwise i don't see the problem with the data.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have table &nbsp;A with columns COL1, COL2, COL3 AND table B with COL4, COL5<br />
I do join and get nice result. The only problem is that on my display I have duplicates (which seems that way to user but they are not).<br />
I would use Group By to make sure user sees only once that data. Example:<br />
<br />
col1 &nbsp; &nbsp; &nbsp; col2 &nbsp; &nbsp; &nbsp; col3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;col4 &nbsp; &nbsp; col5<br />
&nbsp; <br />
00001 &nbsp; nice &nbsp; &nbsp; &nbsp; &nbsp;01/01/03 &nbsp; &nbsp; &nbsp;t &nbsp; &nbsp; &nbsp; &nbsp;b <br />
00001 &nbsp; nice &nbsp; &nbsp; &nbsp; &nbsp;02/02/03 &nbsp; &nbsp; &nbsp;n &nbsp; &nbsp; &nbsp; z<br />
00001 &nbsp; nice &nbsp; &nbsp; &nbsp; &nbsp;03/03/03 &nbsp; &nbsp; &nbsp;s &nbsp; &nbsp; &nbsp; y<br />
<br />
So col1 and col2 are not looking great. How do make it look like<br />
<br />
col1 &nbsp; &nbsp; &nbsp; col2 &nbsp; &nbsp; &nbsp; col3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;col4 &nbsp; &nbsp; col5<br />
&nbsp; <br />
00001 &nbsp; nice &nbsp; &nbsp; &nbsp; &nbsp;01/01/03 &nbsp; &nbsp; &nbsp;t &nbsp; &nbsp; &nbsp; &nbsp;b <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02/02/03 &nbsp; &nbsp; &nbsp;n &nbsp; &nbsp; &nbsp; z<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03/03/03 &nbsp; &nbsp; &nbsp;s &nbsp; &nbsp; &nbsp; y<br />
<br />
I was trying to use group by but it returned only one row (the last one).<br />
<br />
Thank you.<br />
<br />
<br />
<br />
<br />
<br />
<br />

</div>
</div>


Hi Experts,

I have table  A with columns COL1, COL2, COL3 AND table B with COL4, COL5
I do join and get nice result. The only problem is that on my display I have duplicates (which seems that way to user but they are not).
I would use Group By to make sure user sees only once that data. Example:

col1       col2       col3            col4     col5
  
00001   nice        01/01/03      t        b 
00001   nice        02/02/03      n       z
00001   nice        03/03/03      s       y

So col1 and col2 are not looking great. How do make it look like

col1       col2       col3            col4     col5
  
00001   nice        01/01/03      t        b 
                         02/02/03      n       z
                         03/03/03      s       y

I was trying to use group by but it returned only one row (the last one).

Thank you.








Grouping

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.