rollup

Which Oracle version supports cube and rollup?

Particularly, Does it work with 9i Standard? Do you have some easy example that'd allow me to check it? ...

CSS & Javascript rollup file(s)

The Yahoo User Interface library offers rollup support if you use their CDN. I'm using Zend Framework 1.8.0 and was wondering whats he best way to go about replicating this so as all our css or javascript files can be rolledup into one tag - thus one http request. I am using the standard MVC components with a .htaccess file that rewri...

mysql "with rollup" query morphed into a tree structure

Background: I have this "with rollup" query defined in MySQL: SELECT case TRIM(company) when 'apple' THEN 'AAPL' when 'microsoft' THEN 'MSFT' else '__xx__' END as company ,case TRIM(division) when 'hardware' THEN Trim(division) ...

Father-child and sales rollup

Dear Good people I have table of employees and column called managedby. I want to roll actual and target figures up from employee to lead to manager to director and etc. create table ( empid int ,Name varchar(255) ,actual decimal(38,2) ,target decimal(38,2) ,managedby int ) and below is what have done so far: with emp(Period,La...

help with oracle sql rollup

Hi folks, I've written a query to collect some data to display in an auto-updating box & whisker graph in excel. I'd like to use rollup to create summary rows for each type of train_line (PF and MJ) to include in the excel chart. Can I do that using Rollup? I've tried to get my head around Rollup, but I'm not getting far. I've tried...

how to do a iterative rollup in sql

Hi I want to do a rolling sum (of valx) based on previous row value of rolling sum(valy) and the current row value of valx valy=previousrow_valy + valx animal valx valy cat 1 1 cat 3 4 cat 2 6 dog 4 4 dog 6 10 dog 7 17 dog 8 25 ...

Need to add "rollup" of entire dataset to bottom of DataGrid that is paged

In ASP.NET 3.5 I have a datagrid that is bound to a somwehat dynamic datatable. The datatable is created by taking three different tables returned from a dataset and combining them to create one table. It goes like this. The first datatable returns a list of the columns that will be in the final datatable. The second datatable return...

Oracle SQL: ROLLUP not summing correctly

Hi guys, Rollup seems to be working correcly to count the number of units, but not the number of trains. Any idea what could be causing that? The output from the query looks like this. The sum of the Units column in yellow is 53 but the rollup is showing 51. The number of units adds up correctly though... And here's the oracle SQL ...

How do I add totals/subtotals to a set of results without grouping the row data?

I'm constructing a SQL query for a business report. I need to have both subtotals (grouped by file number) and grand totals on the report. I'm entering unknown SQL territory, so this is a bit of a first attempt. The query I made is almost working. The only problem is that the entries are being grouped -- I need them separated in the rep...

jqgrid: how to keep bottom toolbar visible when grid is rolled up?

My jqgrid has a bottom toolbar and changes height depending on the user-agent: $('#titles-table').jqGrid( { . . . height: function(){ return (navigator.userAgent.match(/iPad/i) !=null) ? "100%" : "222px";}(), toolbar : [true,"bottom"] } The grid displays a list of titles which is sometimes very long. Therefore, the grid wil...

I would like to combine ROLLUP with PIVOT - is that an option?

I have been using SELECT Author, ISNULL(MAX(CASE Status WHEN 'Duplicate' THEN NumDocs END),'') AS Duplicate, ISNULL(MAX(CASE Status WHEN 'Failure' THEN NumDocs END),'') AS Failure, ISNULL(MAX(CASE Status WHEN 'Rejected' THEN NumDocs END),'') AS Rejected, ISNULL(MAX(CASE Status WHEN 'Success' THEN NumDocs END),'') AS...

Syntax error in MySQL WITH ROLLUP query?

Any idea why the following query syntax is wrong: SELECT year, sum(profit) FROM BASEDATA b group by year WITH rollup Error Code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near..... MYSQL Version 5.0.77-community-log ...

oracle sql group count

SELECT a,b,count(*) FROM t GROUP BY rollup(a,b) result: a1, b1, 10 a1, b2, 90 a1, , 100 i need: a1, b1, 10, 100 a1, b2, 90, 100 how? ...

Mimic `rollup` function on generic list

I have a generic list of type Element, for example. public class Element { public string Country { get; set; } public string City { get; set; } public int Population { get; set; } } With the following data. var elements = new List<Element> { new Element { Country = "Country A", City = "Barrie", Population = 12 }...