This discussion is archived
0 Replies Latest reply: Nov 2, 2012 12:00 AM by 945595 RSS

How to write group by ???

945595 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points