Is there any diff
Hi,
what is the difference??
SQL> SELECT COUNT(*) FROM tbl_setmnt WHERE SERVICETRAFFIC='';
COUNT(*)
----------
0
SQL> SELECT COUNT(*) FROM tbl_setmnt WHERE SERVICETRAFFIC IS NULL;
COUNT(*)
----------
1238
regards,
Naresh
what is the difference??
SQL> SELECT COUNT(*) FROM tbl_setmnt WHERE SERVICETRAFFIC='';
COUNT(*)
----------
0
SQL> SELECT COUNT(*) FROM tbl_setmnt WHERE SERVICETRAFFIC IS NULL;
COUNT(*)
----------
1238
regards,
Naresh
0