how to return results of disagreement
Hello-
I have a database in which scientists give multiple ratings of different subjects on different days. Each subject is rated by two scientists, to assess their agreement. I am interested in selecting the rows in which they disagree.
The concise version of my table is set up thusly:
Subject_id (int)
Scientist (varchar(20))
day (smallint)
rating1 (smallint)
rating2 (smallint)
rating3 (smallint)
primary key (subject_id, scientist)
so I am looking for an sql statement that will show the subject_ids where the two scientists disagree on any of the three ratings (keeping in mind that they must be rating the same day).
Thanks!
Subject
Views
Written By
Posted
how to return results of disagreement
5624
May 22, 2007 02:56PM
3863
June 13, 2007 03:54AM
3246
September 03, 2008 10:06AM
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.