Select DISTINCT(TO_NUMBER(TO_CHAR(VISIT_DATE, 'YYYY'))) as YEAR from HISTORY
| No. | Subject | Author | Date | Views |
|---|---|---|---|---|
| 6 | DATE -> DAY CONVERT SQL | admin | 2023.05.25 | 40 |
| 5 | Monthly SUM | admin | 2023.05.22 | 40 |
| 4 | ORACLE COLLECTION | admin | 2023.05.08 | 40 |
| 3 | INNER JOIN | admin | 2023.05.19 | 39 |
| 2 | TEST | admin | 2023.05.03 | 38 |
| » | YEAR EXPRESSIONS | admin | 2023.05.25 | 35 |
