Display the total number of records in selection

As described in the paper " Number of records with combined queries , "If we add to an arbitrary selection of a column containing a function COUNT (1), then the value of this column shows the serial number of the row in the selection. This property can easily also be used to display the numerical data of the server information on the total number of the row that contains the selection. Example of use: We have a very simple choice as is evident from the criteria is the output of all products, the number in 2006 is greater than or equal to 100 000 pcs. It is obvious that this criterion satisfies more products . To find out how much using RCOUNT (1) for each row display its serial number is the result: And if we use a column RCOUNT (1) aggregate function MAX () .... Then we get the output column already contains the last line number. For aesthetic reasons it in selecting the "Format columns" denote a hidden because its value is the same in all rows, put it in the view "description." And the result is a composite layout of the post created and sent George Doubravsky - BI / DW consultant company PIKE Electronic. Thanks!(requirement for solving this task was the first United Oracle BI / DW Experts Bootcamp u).