Re: Weighting your select
In SQL, "array" is spelled "table".
A SQL query either retrieves a row or it doesn't. You can't 90% retrieve it. You're going to have to specify how you want to implement 9/10, 2/10 "weighting" etc. Presumably that'll be a calculated score that reflects your weights. Then you'll have to determine a threshold score that rules a particular score in or out. Finally, fro a query that collects such a set of sets, you'll randomly pick one from each.
Subject
Written By
Posted
Re: Weighting your select
July 17, 2015 04:32PM
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.