单选题
Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary Key STUDENT_NAME VARCHAR2(30) COURSE_ID VARCHAR2(10) NOT NULL MARKS NUMBER START_DATE DATE FINISH_DATE DATE You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task?（）
发布日期：2020-04-10
SELECT student_ id, marks, ROWNUM Rank FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99 AND course_id = 'INT_SQL' ORDER BY mark DESC;
SELECT student_id, marks, ROWID Rank FROM students WHERE ROWID <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY mark;
SELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC- 99' AND course_id = 'INT_SQL' ORDER BY mark DESC;
SELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC) WHERE ROWNUM <= 10;
SELECT student id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM <= 10 AND finish date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id 'INT_SQL';
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
CMS专题
CMS专题
其他考试
银行代理保险业务，犹豫期退保业务可由（）前来办理。
二尖瓣狭窄可见（）
邮政合同的内容就是邮政业务活动中的权利义务关系。（）
某公司是一个年销售额（不含税）保持在80万元左右的商业企业，公司年不含税外购货物为60万元左右（含税为60×117%=70.2万元），如果企业作为小规模纳税人的增值税适用税率是3%，申请成为一般纳税人的增值税适用税率是17%，试分析企业可供选择的纳税方案。
社会资本再生产的周期一般包括以下哪几个阶段（）。
父母对子女不关心、不信任，缺乏沟通，忽视他们的要求，或只看到子女的缺点，否定过多，任其自然发展。这种亲子关系属于（）。
正常人尿胆素定性试验为（）
为确诊肿块性质最好采用（ ）。
南平大剧院的舞台宽为18米，长为20米。如图所示，甲、乙两人以相同的速度从A点出发，沿着舞台边缘朝不同方向奔跑直到相遇。问：以下哪个坐标图能准确描述两人之间的直线距离与时间的关系（横轴为时间，纵轴为直线距离）？
甲、乙、丙、丁四位球迷有一段对话。甲说：“Y球队能进入决赛。”乙说：“如果X球队能进入决赛，那么Y球队也能进入决赛。”丙说：“我看Y球队不能进入决赛，但X球队能进入决赛。”丁说：“X球队不能进入决赛。”如果四人中只有一人是对的，那么可以推出（ ）。
暂无相关推荐~
Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary...
Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary...
Examine the structure of the STUDENTS table: You need to create a report of the ...
Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary...
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: Evaluate this SQL...
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. EMPLO...
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NA...
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn n...
Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables: Which MERGE sta...
Examine the structure of the EMPLOYEES table: You issue these statements: At the...