Quiz 14
Quiz yourself on window functions and DECIMAL data type in MySQL.
We'll cover the following...
Question # 1
Q
Given the following Students table, which function has been used to assign ranks to rows based on the Marks column as shown:
Students
| Name | Marks | Row_Number |
|---|---|---|
| A | 89 | 2 |
| B | 65 | 5 |
| C | 74 | 4 |
| D | 91 | 1 |
| E | 89 | 3 |
A)
ROW_NUMBER()
B)
RANK()
C)
DENSE_RANK()
Ask