Hot answers tagged oracle-11g-r2
A possible solution based on set operations. From my understanding you have to display all rows that contain a 'ticket' in the status fields and all rows with an 'import' in the status field where there is not a similar row with a 'ticket' in the status field. select id,name,testfield,status from mytable where status='ticket' union select ...
Only top voted, non community-wiki answers of a minimum length are eligible