just sql override in SQ t/r: select col1..,sum(sal) from table

how to calculate sum(sal) with out using aggregator satge

Question Posted / jz

Answer Posted / jz

just sql override in SQ t/r:
select col1..,sum(sal) from table_nme group by (col)

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the different types of data warehousing?

1009

Whether dimension table can have numeric value?

1241

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1110

Why facts table is useful in representing the data?

1048

Explain what are slowly changing dimensions?

1074

What is the difference between a primary and secondary actor in use case modeling?

1129

explain about balanced dimension,

1033

How to test report in reportnet?

1054

Explain vldb?

1080

How do you setup Lo-cockpit?

3240

How to create different types of templates?

1032

What are the different types of fact tables used in data warehousing?

1039

a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

2521

How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

973

Who needs data warehousing?

1126