题目内容
（请给出正确答案）
[主观题]
rowid和rownum有什么不同？区别在哪里？
如搜索结果不匹配，请 联系老师 获取答案
A.LEVEL
B.ROW_NUMBER()
C.ROWNUM
D.COLUMN
E.ROWID
更多“rowid和rownum有什么不同？区别在哪里？”相关的问题
第2题
Examine the structure of the STUDENTS table:STUDENT_ID NUMBER NOT NULL, Primary KeySTUDENT
_NAME VARCHAR2(30)COURSE_ID VARCHAR2(10) NOT NULLMARKS NUMBERSTART_DATE DATEFINISH_DATE DATEYou 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？ （）
点击查看答案
A. 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;
B. 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;
C. 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;
D. 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;
E. 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‘;
