0 Replies Latest reply: Nov 2, 2012 2:00 AM by 945595 RSS

    How to write group by ???

    945595
      Hi all,
      I have problem with GROUP BY clause.
      My query is

      select case .........end shift, t.*
      from table1
      where ....
      gruop by case.....end

      Its throws me an error. But if the remove the column "t.*" then if i write the satement

      select case .........end shift
      from table1
      where ....
      gruop by case.....end

      its fetches me the output.

      But I want that column also what I should do, how should i group. Please help me.

      Thanks in advance.
      Regards
      Uraja