MySQL Forums
Forum List  »  MySQL Query Browser

excluding the rows
Posted by: tribhuwan tiwari
Date: June 01, 2012 03:20AM

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.

Options: ReplyQuote


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.