excluding the rows
Hi
I have a table that has the data given below
ReportId ThreadId ProductId DepartmentId
406 87 71 1
406 91 71 1
406 91 71 55
407 88 71 53
407 89 71 1
407 90 71 54
407 90 71 55
and so on..........
We have two type of DepartmentIds 55 and (1,53,54)
I want to select all rows but one specific requirement is there for eg row 2 & 3 where all columns has same value except DepartmentId. If the value of department id is 55 then i want only that row and exclude the row having id (1,53,54).
Similarly for row 6 & 7 I want row 7 not the row 6. There are so many rows having this condition. Please help how to do this.
Subject
Written By
Posted
excluding the rows
June 01, 2012 03:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.