Aug 302013
select what_i_what
from (
  select *
  from   job_candidates
  where  skills = :the_job_description
  and    personality like:able
  order  by (ability+job_fit) desc
where rownum <= 1;

The perfect candidate

While I'm sure there's hundreds of databases around the world with job seekers in, 
I doubt any are complete enough for this query to find the right people. I guess 
we're stuck with reviewing CVs and interviews until then

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>