NOT NULL VALUE
Syntax:
SELECT c_id,c_name, c_age,c_experince
FROM Teacher
WHERE Experience IS NOT NULL;
Example:
c_id |
c_name |
c_age |
c_experince |
01 |
Frank |
37 |
7 |
02 |
Lennin |
27 |
|
03 |
andy |
41 |
6 |
04 |
Peter |
29 |
3 |
05 |
Mike |
44 |
|
Result:
c_id |
c_name |
c_age |
c_experince |
01 |
Frank |
37 |
7 |
03 |
andy |
41 |
6 |
03 |
andy |
41 |
6 |
04 |
Peter |
29 |
3 |