1.

What Is The Meaning Of Fields Roll_up_level 1 , Roll_up_level 2 And Roll_up_level 3 In Resa Glcross Reference Screen 'saglcros.fmb'?

Answer»

Total - Roll Ups :

Roll-ups ALLOW a total to produce multiple values, it is equivalent to the part of the GROUP BY clause in the SQL SELECT statement that combines any rows that WOULD have duplicate values in the grouped by field

For example :

SELECT count/sum(Value to be Totaled)

FROM REALMS

WHERE restrictions + JOINS

GROUP BY roll ups

Total - Roll Ups :

Roll-ups allow a total to produce multiple values, it is equivalent to the part of the GROUP BY clause in the SQL SELECT statement that combines any rows that would have duplicate values in the grouped by field

For example :

SELECT count/sum(Value to be Totaled)

FROM realms

WHERE restrictions + joins

GROUP BY roll ups


Discussion

No Comment Found

Related InterviewSolutions