Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

ISNULL and NULLIF functions

Theory

Using ISNULL() function to solve a problem

Report a typo

Suppose there is data on the students from a school. But the data has a significant issue, some of the student's grades don't exist. How would you solve the problem? Take the data from the table "Students" from the column "Grades". Replace the absent grades with 'Not Available' if any NULLs are found.

studentID

firstName

lastName

Grades

1

John

Jackson

A

2

Henry

Roberts

C

3

Wade

Thompson

4

Smith

Jones

Enter a short text
___

Create a free account to access the full topic