MySQL Forums
Forum List  »  InnoDB

how to return results of disagreement
Posted by: Brent Morgan
Date: May 22, 2007 02:56PM

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
how to return results of disagreement
5624
May 22, 2007 02:56PM
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.