Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by wilkinsonm
-
using decode and column alias with "group by"?
You should see the smile on my face now!! that worked like a charm! What's more, I learned something new about Oracle SQL :-) thanks BJCooperIT!! Mark- wilkinsonm
- Post #3
- Forum: ANSI_SQL
-
using decode and column alias with "group by"?
Hi SQL-ers! I've been fighting this query for two days straight, and I have tried it in every different convulution that I can think of, but it just isn't happy. The problem seems to lie in my inability to "group by" the column that I alias as chr_strand (line 15). If I try to group...- wilkinsonm
- Thread
- Replies: 3
- Forum: ANSI_SQL
