9 Replies Latest reply: Feb 8, 2012 5:58 AM by Jason Michaelides RSS

    MIN VALUE AND COLUMN NAME

      I am having below table

       

      ITEMCITY 01CITY 02CITY 03
      ITEM 01102013
      ITEM 0281212
      ITEM 03242014
      ITEM 04131520
      ITEM 05181414
      ITEM 06201624
      ITEM 07241813
      ITEM 08262012

      Need answer as below showing MINIMUM VALUE against EACH line.

       

      ITEMCITY 01CITY 02CITY 03MIN PRICECITY HAVING MIN PRICE
      ITEM 0110201310CITY 01
      ITEM 02812128CITY 01
      ITEM 0324201414CITY 03
      ITEM 0413152013CITY 01
      ITEM 0518141414CITY 02, CITY 03
      ITEM 0620162416CITY 02
      ITEM 0724181313CITY 03
      ITEM 0826201212CITY 03

       

      Thanks in advance...

      Regards,

      Manish