Have a Question ?

Home / Answered Questions / Other / find-the-skill-name-and-the-number-of-agents-with-that-skill-for-the-skill-posessed-by-the-most-agen-aw685

(Solved): Find The Skill Name And The Number Of Agents With That Skill, For The Skill Posessed By The Most Age...


Find the skill name and the number of agents with that skill, for the skill posessed by the most agents.

skillrel skill id agent id skill skill_id skill

skillrel skill id agent id skill skill_id skill


We have an Answer from Expert View Expert Answer

Expert Answer


Table Design create table skillrel(skill_id number(4),agent_id number,primary key(skill_id,agent_id)); desc skillrel; insert into skillrel values(101,201); insert into skillrel values
We have an Answer from Expert
Buy This Answer $5

-- OR --

Subscribe To View Unlimited Answers
Subscribe $12 / Month