You are viewing a single comment's thread. Return to all comments →
I can't use this script. In the name field, its printed 1, instead of the correct name. This is the output returned:
1 10 95 1 10 94 1 10 96 1 10 100 1 10 99 1 9 89 1 9 88 1 9 81 1 9 87 1 9 80 1 9 84 1 8 77 1 8 78 1 8 74 1 8 76 1 8 77 NULL 7 64 NULL 7 66 NULL 6 55 NULL 4 34 NULL 3 24
in place of 'SELECT NAME = CASE' in first line, use 'SELECT CASE' because I think the former one is evaluating in 1 and 0(boolean)
why should we use case..? pls explain..
It adds a conditional data value for the name column. The name of the student in the current row or NULL
The Report
You are viewing a single comment's thread. Return to all comments →
I can't use this script. In the name field, its printed 1, instead of the correct name. This is the output returned:
in place of 'SELECT NAME = CASE' in first line, use 'SELECT CASE' because I think the former one is evaluating in 1 and 0(boolean)
why should we use case..? pls explain..
It adds a conditional data value for the name column. The name of the student in the current row or NULL