sorting rows

[cihatkarli]

i have a 4 cell table

example

1 AAAA CCCC DDDD
2 CCCC KKKK BBBB
3 DDDD NNNN AAAA

i want every line's output sorted alpabethically

like this.

1 AAAA CCCC DDDD
2 BBBB CCCC KKKK
3 AAAA DDDD NNNN


tried to do with excel but no luck.

 

[feherke]

Hi

The SQL databases usually can sort records. I never heard about one able to sort fields.

What you want seems easier to solve in the application which queries the data.

What do you try to accomplish more exactly ?

Feherke.

http://rootshell.be/~feherke/

 

[r937]

what a wacky request

caution: this is untested, and if it doesn't work, you can surely figure out the logic yourself, yes?

select id
     , case when colA <= colB
             and colA <= colC
            then colA
            when colB <= colC
            then colB
            else colC       as col_1  
     , case when colA <= colB
             and colB <= colC
            then colB
            when colB <= colC
             and colC <= colA
            then colC
            else colA       as col_2  
     , case when colA <= colB
             and colB <= colC
            then colC
            when colB <= colC
             and colC <= colA
            then colA
            else colC       as col_3
  from daTable

r937.com | rudy.ca

 

[cihatkarli]

it's a quick job that my boss wanted.

r397 your query gives an syntax error.

 

[feherke]

Hi

Try to close the [tt]case[/tt]s :

select id
     , case when colA <= colB
             and colA <= colC
            then colA
            when colB <= colC
            then colB
            else colC
            [red]end[/red]             as col_1  
     , case when colA <= colB
             and colB <= colC
            then colB
            when colB <= colC
             and colC <= colA
            then colC
            else colA
            [red]end[/red]             as col_2  
     , case when colA <= colB
             and colB <= colC
            then colC
            when colB <= colC
             and colC <= colA
            then colA
            else colC
            [red]end[/red]             as col_3
  from daTable

Feherke.

http://rootshell.be/~feherke/

 

[cihatkarli]

this is close to what i want. thanks