题目内容
(请给出正确答案)
[主观题]
● 设有职工表emp(Eno,Ename,Sex,Age)(Eno为职工号,Ename为职工姓名,Sex为性别,Age为年龄)和salar
y(Eno,Hour,Month,Wage)(Hour为工作时长为多少小时,Month表示几月份,Wage为薪水),建立一个视图V-Salary(Eno,Ename,Hour,Month,Wage),并按Eno升序排序的SQL语句为:
(1)CREATE ()
AS SELECT emp.Eno,emp.Ename ,salary.Hour,salary.Month,salary.Wage
FROM emp, salary
WHERE emp.Eno=salary.Eno
ORDER BY ENO
在此视图上查均月工资在3000以上的职工工资情况的SQL语句为:
SELECT Eno,Ename,AVG(Wage)
FROM V-Salary
GROUP BY ()
HAVING AVG(Wage)>3000
()
A. CREATE TABLE V-Salary(emp.Eno,emp.Ename,salary.Hour,salary.Month,salary.Wage)
B. CREATE VIEW V-Salary(Eno,Ename,Hour,Month,Wage)
C. CREATE TABLE V-Salary(Eno,Ename,Hour,Month,Wage)
D. CREATE INDEX V-Salary(Eno,Ename,Hour,Month,Wage)
()
A. Eno B.Ename
C.Month D.Wage
如搜索结果不匹配,请 联系老师 获取答案