Use of Oracle Partition by

Requirements: To find the largest line of Frecamount information in Fsendccname Group;

Solution 1:

SELECT T0. Fsendccname,t0. Frecccname
From tmp0ce8366758a811e781d70050568 T0
INNER JOIN
(SELECT fsendccname, MAX (frecamount) frecamount
From tmp0ce8366758a811e781d70050568
WHERE fgrouping = 0
GROUP by Fsendccname
ORDER by Fsendccname, Frecamount DESC) T1
On T1. Fsendccname = T0. Fsendccname
and T1. Frecamount = T0. Frecamount
WHERE T0. fgrouping = 0;

Solution 2:

-- Sort by order SELECT row_number () over (PARTITION by Fsendccname ORDER by Frecamount DESC)                  rn,               A. *           from tmp0ce8366758a811e781d70050568 a          WHERE = 0  and Fgrouplevel<>1

The results appear as follows:

Solution 3:

-- Jump Sort SELECT  over byORDERby DESC)                  RN,               A. *           from tmp0ce8366758a811e781d70050568 A          WHERE = 0  and Fgrouplevel<>1

The results appear as follows:

Solution 4:

-- Sequential sequencing SELECT  over byORDERby DESC)                  RN,               A. *           from tmp0ce8366758a811e781d70050568 A          WHERE = 0  and Fgrouplevel<>1

The results appear as follows:

Use of Oracle Partition by