SQL Language (MOSC)

MOSC Banner

Removing null value records

edited Mar 10, 2011 3:27AM in SQL Language (MOSC) 10 commentsAnswered
Hi ,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center