Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
1 Search Results Found
1 Forum: SQL & PL/SQL «» Posted on: Mon, 27 February 2012 17:42 «» By: Barbara Boehmer
Re: pivot query
Yes, it is because we need to use an aggregate function. Notice the error message that you get if you try to use 11g pivot without an aggregate function: SCOTT@orcl_11gR2> SELECT * 2 FROM (SELECT course, member, 3 ROW_NUMBER ()...

Current Time: Mon Jun 17 13:41:09 CDT 2019