Multimedia Test System
 
STUDENT
 
FACULTY
 
SCHOOL
 
SUPPORT
 
PUBLIC
 
SIGNUP
DAILY QUIZ
 
     
  M U L T I M E D I A    T E S T    S Y S T E M
 
Question of the Day for 11/22/2026
 
Subject: Database Management


List the employees who earn one of the three highest salary amounts. The top salaries are 5000 (KING), 3000 (FORD, SCOTT), and 2975 (JONES). Which filter on r, computed in an inline view as ... OVER (ORDER BY sal DESC) AS r, is correct?
  1. ROW_NUMBER() with r <= 3
  2. RANK() with r <= 3
  3. NTILE(3) with r = 1
  4. DENSE_RANK() with r <= 3

Email Subscriptions: To receive Question of the Day via email, sign up for a student account and subscribe to the mailing lists of your choice on AP, SAT, and MCAT exams and college subjects.
     
 
Blog Posts    News Digest    Contact Us    About Developer    Privacy Policy

©1997-2026 ecourse.org. All rights reserved.