asked on
SELECT wo_number, first_name, last_name
FROM (SELECT wo_number,
first_name,
last_name,
ROW_NUMBER() OVER(PARTITION BY wo_number ORDER BY first_name, last_name) rn,
COUNT(*) OVER (PARTITION BY wo_number) cnt
FROM ba_view_wo_labor
WHERE skill NOT LIKE '%INSPECTOR')
WHERE cnt > 1 AND rn = 1
ORDER BY wo_number
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
TRUSTED BY
try this:
Open in new window
RegardsDavid
PS Not going to perform very well on larger datasets