hi,
need help with the following query, for the same origin and destiny,if there is a pricetype=3 show the row with the pricetype=3 else show the the row with pricetype=1
Example:
LineCode Origin Destiny Pricetype
2 606 618 3
2 606 618 1
2 607 618 1
3 606 618 1
3 607 618 1
3 606 618 3
Result:
LineCode Origin Destiny Pricetype
2 606 618 3
2 607 618 1
3 607 618 1
3 606 618 3
Thanks.