Here is the Student table and first 5 columns are keys
| emplid | Event | Career | CAR_NBR | CATALOG_NBR | ACAD_PROG | STRM | TERM_DESCR30 | COURSE_TITLE | UNT_TAKEN |
|---|---|---|---|---|---|---|---|---|---|
| 100 | 699 | PGRD | 0 | 73A | 57 | 410 | Trimester 1 2024 | Title-1 | 10 |
| 100 | 699 | PGRD | 0 | 74N | 57 | 410 | Trimester 1 2024 | Title-2 | 10 |
| 100 | 699 | PGRD | 0 | 79N | 57 | 410 | Trimester 1 2024 | Title-3 | 20 |
| 200 | 280 | PGRD | 2 | 71A | 32 | 410 | Trimester 1 2024 | Title-4 | 10 |
Now I need to prepare a sql view which gives me the output in HTML format(one field- HTML String).
In down stream people uses this sql view’s output to any webpage to show the result in a table format.
expected outcome would be like below
|EMPLID |EVENT_NBR| CAREER| STDNT_CAR_NBR |HTML String
| ——– | ——– |——–|——| ——– |
|100 |699 |PGRD |0 |
|200 |280 |PGRD |2 |
Here the HTML String should represent data in a table format with fields CATALOG_NBR, TERM_DESCR30,COURSE_TITLE , UNT_TAKEN.
For example if I place the HTML String in a web page it should show like below for student 100…
| HTML String | |||
|---|---|---|---|
| CATALOG_NBR | TERM_DESCR30 | COURSE_TITLE | UNT_TAKEN |
| Trimester 1 2024 | 73A | Title-1 | 10 |
| Trimester 1 2024 | 74N | Title-2 | 10 |
| Trimester 1 2024 | 79N | Title-3 | 20 |
Appreciate your help on this.
Arjun321 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.