Removing null value records
My table is having like below data .
USERID EMPID
KCSDHOK001 0010043221
AGRDFAD001
HMODFOR001 0010043236
LADFLLE001 0010043241
VCXCZUB001
ICAWENO001 0010043251
I need the output like this
KCSDHOK001 0010043221
HMODFOR001 0010043236
LADFLLE001 0010043241
ICAWENO001 0010043251
I user below query but did not work.
select USERID,EMPLID from TABLE_NAME where EMPLID IS NOT NULL;
Please help
Thanks