Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


boostr.in questions - Question:Examine the structure of the STUDENTS table given below:


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

A re

port is to be created of ten students who achieved the highest ranking in the course INT_SQL and completed the course in the year 1999.
Which SQL statements 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 marks 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 marks;
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 marks 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';

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes
13 views



Related Hot Questions



Government Jobs Opening


...