[Solved] how to use ‘GROUP BY’ function with below query

by


Do you mean like this?

SELECT * FROM (
    SELECT
        a.id,
        a.name,
        c.code,
        a.active_dt,
        a.inactive_dt,
        b.category,
        COUNT(1) OVER(PARTITION BY a.id, a.name, c.code) AS CNT
    FROM
        student a,
        class b,
        descrip c
    WHERE
        a.id=b.id AND
        a.id=c.id
)
WHERE CNT > 1

0

solved how to use ‘GROUP BY’ function with below query