>Hello,
>
>
>I have a table which consists of 5 columns.
>There are a large number of rows that have the same values for the
>first 4 columns and the last column is the only thing that differs.
Sir, this can be interpreted two different ways. Either
col1=col2=col3=col4, or row1.col1=row2.col1, r
Have you tried something like this?
SELECT * FROM table_name where col1=col2 and col2=col3 and col3=col4 and
col4!=col5;
Greg Skouby wrote:
>
> Hello,
>
> I have a table which consists of 5 columns.
> There are a large number of rows that have the same values for the
> first 4 columns and the
Hello,
I have a table which consists of 5 columns.
There are a large number of rows that have the same values for the
first 4 columns and the last column is the only thing that differs.
I would like to grab all the rows that have these identical
columns so I can store it into one rows with all
