Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: Alias for a CASE WHEN expression in a SELECT cannot be used in GROUP BY?

Re: Alias for a CASE WHEN expression in a SELECT cannot be used in GROUP BY?

From: Jining Han <jining.han_at_gmail.com>
Date: 4 Mar 2006 12:14:03 -0800
Message-ID: <1141503243.148040.240660@z34g2000cwc.googlegroups.com>

Yes, a view (inline or not) is OK, but I just want to be able to explain.

Thanks
JH Received on Sat Mar 04 2006 - 14:14:03 CST

This message: [ Message body ]
Next message: DA Morgan: "Re: Number of Columns in a table."
Previous message: Michel Cadot: "Re: One OS user for two installations"
In reply to: Mark C. Stock: "Re: Alias for a CASE WHEN expression in a SELECT cannot be used in GROUP BY?"
Next in thread: Sybrand Bakker: "Re: Alias for a CASE WHEN expression in a SELECT cannot be used in GROUP BY?"
Reply: Sybrand Bakker: "Re: Alias for a CASE WHEN expression in a SELECT cannot be used in GROUP BY?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US