Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest rank

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest rank

Post by answerhappygod »

Examine the structure of the STUDENTS table: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?
Examine The Str 1
Examine The Str 1 (58.66 KiB) Viewed 135 times
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. SELECTstudent id, marks, ROWNUM Rank FROM(SELECT student_id, marks FROM students ORDER BY marks) WHEREROWNUM <= 10 ANDfinish date BETWEEN 01-JAN-99 AND 31-DEC-99 ANDcourse_id = INT_SQL;
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply