I want to create queries to remove/extract redundant rows having similar versions. For example 13.0, 13.0.0, 13.0.0.0 are the same for SQL Server. So I want to delete the rows having less refined version of product - 13.0, 13.0.0 - and be left only with versions 13.0.0.0 and 13.0.0.275.
Is there any way to do this using some SQL query?
As versions 13.0, 13, 13.0.0 and 13.0.0.0 are the same in all sense... so I want to keep the most detailed version out of them, that is 13.0.0.0, and delete other versions. But version 13.0.0.725 and 13.0.0.0 are different so I want to keep this record as it is but for particular product say SQL Server.
The output that I want from the graphical example:
SQL Server with 13.0.0.0 version
SQL Server with 13.0.0.275 version
Visual Studio with 13.0.0.0 version
Visual Studio with 13.0.0.275 version
Another example is-- If there are versions like 2, 2.0, 2.1.0, then in this case, the record having version 2 and 2.0 are the same so I want to keep the more detailed version of same version and delete the rest. The record will show having version 2.0 and 2.1.0.
Is there any way to achieve the same using SQL queries?