Re: equivalent for 'compute' in sql server
Yes, that's because of your group by. You are making groups per pub_id value. If you want to see the more detailed levels too, add columns to the group by list accordingly:
group by pub_id, title_id, price, pub_date
Subject
Views
Written By
Posted
5387
November 04, 2005 06:16AM
3265
November 04, 2005 09:03AM
3218
November 05, 2005 04:04AM
2851
November 07, 2005 05:21AM
Re: equivalent for 'compute' in sql server
8971
November 07, 2005 06:02AM
4048
November 05, 2005 07:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.