GROUP BY clause and CASE statement – need help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rahulephp
    New Member
    • Sep 2009
    • 59

    GROUP BY clause and CASE statement – need help

    I have a table with 4 columns

    Table name = products
    Column name = product_id, product_program name, product_title, model_number

    When I use GROUP BY with model_number, it alway returns me the info of product (ebay) which comes first in the queue.
    But i want to get the title from 'argos' if not null else 'buy' if not null etc.

    The below query doesn't works for me.

    Code:
    SELECT *,
    (
    case(true)
    WHEN product_programname = 'argos' AND product_programname IS NOT NULL
    THEN product_title
    
    WHEN product_programname = 'buy' AND product_programname IS NOT NULL
    THEN product_title
    
    WHEN product_programname = 'amazon' AND product_programname IS NOT NULL
    THEN product_title
    
    WHEN product_programname = 'ebay' AND product_programname IS NOT NULL
    THEN product_title
    
    WHEN product_programname = 'next' AND product_programname IS NOT NULL
    THEN product_title
    
    END
    ) as final_title
    
    FROM products
    GROUP BY model_number
    Please assist how come it'll be possible.
Working...