A client is asking me to review several tables of user entered data to find data anomolies (basically bad values entered by fat fingering or misunderstanding of the开发者_运维知识库 question). Each table has ~20 fields and I don't really want to write 20 queries for each table.
Is there an easier way to go about this if I were to specify that an outlier is 10 percent over or under the median?
精彩评论