function FileData_Pairs(x) { x.t("statements","extensions"); x.t("extensions","salesforce"); x.t("example","example"); x.t("example","correlated"); x.t("example","second"); x.t("example","correlating"); x.t("example","select"); x.t("example","finding"); x.t("example","following"); x.t(".deptno","emp.deptno"); x.t("exist","virtual"); x.t("within","select"); x.t("table","referred"); x.t("table","name"); x.t("table","returned"); x.t("table","itself"); x.t("table","containing"); x.t("question","answer"); x.t("once","row"); x.t("table1","t_alias1"); x.t("table2","t_alias2"); x.t("alias","correlated"); x.t("alias","emp"); x.t("tables","views"); x.t("uses","alias"); x.t("statement","example"); x.t("statement","correlated"); x.t("statement","select"); x.t("statement","parent"); x.t("statement","assigns"); x.t("statement","subquery"); x.t("statement","query"); x.t("statement","called"); x.t("statement","following"); x.t("statement","returns"); x.t("main.deptno","example"); x.t("t_alias1","expr"); x.t("t_alias1","column"); x.t("delete","table1"); x.t("delete","statement"); x.t("expr","table2"); x.t("expr","rel_operator"); x.t("t_alias2","t_alias1.column"); x.t("explicitly","qualified"); x.t("multiple","employees"); x.t("correlated","subqueries"); x.t("correlated","subquery"); x.t("correlated","column"); x.t("count","emp"); x.t("emp","table"); x.t("emp","exists"); x.t("emp","x.deptno"); x.t("emp","outer"); x.t("emp","e.deptno"); x.t("emp","deptno"); x.t("emp","sal"); x.t("single","column"); x.t("dept.deptno","unique"); x.t("earn","average"); x.t("exceed","department"); x.t("false","grammar"); x.t("duplicate","rows"); x.t("referred","parent"); x.t("depends","value"); x.t("true","cardinality"); x.t("d.deptno","correlated"); x.t("processed","parent"); x.t("managername","emp"); x.t("operation","retrieves"); x.t("dept","outer"); x.t("dept","e.deptno"); x.t("dept","unique"); x.t("dept","predicate"); x.t("dept","main"); x.t("dept","dname"); x.t("name","parent"); x.t("references","column"); x.t("t_alias1.column","t_alias2.column"); x.t("t_alias1.column","rel_operator"); x.t("virtual","table"); x.t("average","statement"); x.t("average","salaries"); x.t("average","salary"); x.t("sales","exists"); x.t("exists","select"); x.t("exists","predicate"); x.t("exists","subquery"); x.t("x.deptno","deptno"); x.t("[not]","subquery"); x.t("[not]","value1"); x.t("determine","whether"); x.t("determine","employees"); x.t("second","select"); x.t("retrieves","data"); x.t("body","expression"); x.t("correlating","table"); x.t("select_list","table1"); x.t("outer",".deptno"); x.t("outer","manager"); x.t("top-level","query"); x.t("select","statement"); x.t("select","expr"); x.t("select","count"); x.t("select","emp"); x.t("select","managername"); x.t("select","dept"); x.t("select","select_list"); x.t("select","deptno"); x.t("select","column_list"); x.t("select","avg"); x.t("select","empno"); x.t("select","update"); x.t("appears","body"); x.t("e.deptno","dept.deptno"); x.t("e.deptno","d.deptno"); x.t("number","deptno"); x.t("deptno","example"); x.t("deptno","main.deptno"); x.t("deptno","multiple"); x.t("deptno","emp"); x.t("deptno","dept"); x.t("deptno","select"); x.t("deptno","ename"); x.t("deptno","order"); x.t("parent","statement"); x.t("parent","examples"); x.t("specifies","values"); x.t("against","subquery"); x.t("against","compare"); x.t("unique","select"); x.t("unique","predicate"); x.t("unique","subquery"); x.t("whether","duplicate"); x.t("departments","case"); x.t("t_alias2.column","delete"); x.t("t_alias2.column","note"); x.t("t_alias2.column","update"); x.t("finding","department"); x.t("row","processed"); x.t("row","values"); x.t("salaries","exceed"); x.t("salaries","departments"); x.t("returned","subquery"); x.t("returned","grammar"); x.t("salesforce","driver"); x.t("reference","top-level"); x.t("rows","exist"); x.t("salary","department"); x.t("salary","information"); x.t("assigns","alias"); x.t("greater","otherwise"); x.t("ename","deptno"); x.t("ename","sal"); x.t("whose","salaries"); x.t("compared","against"); x.t("subqueries","explicitly"); x.t("subqueries","correlated"); x.t("subqueries","subqueries"); x.t("subqueries","query"); x.t("subqueries","sql"); x.t("specifically","computes"); x.t("qualified","table"); x.t("sal","emp"); x.t("sal","select"); x.t("predicate","true"); x.t("predicate","exists"); x.t("predicate","specifies"); x.t("predicate","unique"); x.t("predicate","predicate"); x.t("predicate","used"); x.t("value","[not]"); x.t("value","row"); x.t("column_list","table2"); x.t("(sal)","emp"); x.t("main","select"); x.t("avg","(sal)"); x.t("manager","select"); x.t("subquery","example"); x.t("subquery","single"); x.t("subquery","references"); x.t("subquery","determine"); x.t("subquery","select"); x.t("subquery","greater"); x.t("subquery","specifically"); x.t("subquery","subquery"); x.t("subquery","query"); x.t("subquery","answers"); x.t("subquery","evaluated"); x.t("subquery","returns"); x.t("subquery","grammar"); x.t("expression","appears"); x.t("expression","select"); x.t("multiple-part","question"); x.t("computes","average"); x.t("department","average"); x.t("department","number"); x.t("department","grammar"); x.t("query","operation"); x.t("query","expression"); x.t("query","nested"); x.t("query","called"); x.t("data","tables"); x.t("data","employees"); x.t("value1","value2"); x.t("information","uses"); x.t("nested","within"); x.t("result","returned"); x.t("result","values"); x.t("value2","value"); x.t("empno","ename"); x.t("examples","example"); x.t("values","select"); x.t("values","against"); x.t("values","compared"); x.t("answer","depends"); x.t("case","correlated"); x.t("called","select"); x.t("called","subquery"); x.t("column","table"); x.t("column","select"); x.t("column","result"); x.t("column","names"); x.t("column","rel_operator"); x.t("otherwise","false"); x.t("note","correlated"); x.t("emp.deptno","example"); x.t("answers","multiple-part"); x.t("employees","earn"); x.t("employees","select"); x.t("employees","whose"); x.t("itself","select"); x.t("cardinality","subquery"); x.t("order","deptno"); x.t("following","example"); x.t("following","statement"); x.t("dname","sales"); x.t("used","determine"); x.t("containing","salary"); x.t("compare","result"); x.t("evaluated","once"); x.t("returns","row"); x.t("returns","data"); x.t("sql","statements"); x.t("driver","subqueries"); x.t("names","correlated"); x.t("views","reference"); x.t("rel_operator","select"); x.t("rel_operator","t_alias2.column"); x.t("update","table1"); x.t("update","delete"); x.t("grammar","exists"); x.t("grammar","select"); x.t("grammar","unique"); x.t("grammar","value"); }