locked
Multiple fileds. distinct RRS feed

  • Question

  •  

    Hi,

     

    I have rows which like

    Code Snippet

    1    yes

    2    no

    3    yes

    4    yes

    5    yes

    6    no

    .....

     

     

    I want to obtain one column

    Code Snippet

    yes

    no

     

     

     

    How is the query?

     

    Thanks

    Friday, June 6, 2008 3:48 PM

Answers

  •  

    Code Snippet

    SELECT DISTINCT c2 FROM table

     

     

    Friday, June 6, 2008 10:54 PM