programplug Logo



SQL Not Null Value

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