Quiz 14
Quiz yourself on window functions and DECIMAL data type in MySQL.
We'll cover the following...
We'll cover the following...
Question # 1
1.
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()
1 / 1