Jelabai supratau klausima bet gal distinct? tipo select  distinct laukai, tai negrazins keliu vienodu irasu.

"NicMC" <jzs@freemail.lt> wrote in message news:ir5gs4$jdk$1@trimpas.omnitel.net...
> Sveiki,
> 
> Lenta:
> +-------------------+
> | ID1 | ID2 | Value |
> +-------------------+
> |  A  |  B  |  X    |
> +-------------------+
> |  B  |  A  |  X    |
> +-------------------+
> |  C  |  B  |  X    |
> +-------------------+
> |  B  |  C  |  Y    |
> +-------------------+
> 
> 
> Reikia išrinkti unukalius įrašus, unikaliu neklaikant ID1 ir ID2 laukų 
> apkeitimo vietomis, t.y. A | B = B | A
> 
> +-------------------+
> | ID1 | ID2 | Value |
> +-------------------+
> |  A  |  B  |  X    |
> +-------------------+
> |  C  |  B  |  X    |
> +-------------------+
> |  B  |  C  |  Y    |
> +-------------------+
> 
> Kaip suselektint?