题目内容

Asubquerycanbeusedto().

A. creategroupsofdata
B. sortdatainaspecificorder
C. convertdatatoadifferentformat
D. retrievedatabasedonanunknowncondition

查看答案
更多问题

Excel计算参数的平均数函数是()。

A. COUNT
B. AVERAGE
C. MAX
D. SUM

Given: What is the result?()

A. test
C. An exception is thrown at runtime.
D. Compilation fails because of an error in line 1.
E. Compilation fails because of an error in line 4.
F. Compilation fails because of an error in line 5.

Given: What is the result?()

A. 0.0
B. Compilation fails.
C. A ParseException is thrown by the parse method at runtime.
D. A NumberFormatException is thrown by the parse method at runtime.

ClicktheExhibitbuttontoexaminethedataoftheEMPLOYEEStable. WhichstatementliststheID,name,andsalaryoftheemployee,andtheIDandnameoftheemployee'smanager,foralltheemployeeswhohaveamanagerandearnmorethan4000?()

A. SELECTemployee_id"Emp_id",emp_name"Employee",salary,employee_id"Mgr_id",emp_name"Manager"FROMemployeesWHEREsalary>4000;
B. SELECTe.employee_id"Emp_id",e.emp_name"Employee",e.salary,m.employee_id"Mgr_id",m.emp_name"Manager"FROMemployeeseJOINemployeesmWHEREe.mgr_id=m.mgr_idANDe.salary>4000;
C. SELECTe.employee_id"Emp_id",e.emp_name"Employee",e.salary,m.employee_id"Mgr_id",m.emp_name"Manager"FROMemployeeseJOINemployeesmON(e.mgr_id=m.employee_id)ANDe.salary>4000;
D. SELECTe.employee_id"Emp_id",e.emp_name"Employee",e.salary,m.mgr_id"Mgr_id",m.emp_name"Manager"FROMemployeeseSELFJOINemployeesmWHEREe.mgr_id=m.employee_idANDe.salary>4000;
E. SELECTe.employee_id"Emp_id",e.emp_name"Employee",e.salary,m.mgr_id"Mgr_id"m.emp_name"Manager"FROMemployeeseJOINemployeesmUSING(e.employee_id=m.employee_id)ANDe.salary>4000;

答案查题题库