sql - Phone number issues -


i trying write report , in report there sub query pull phone numbers based on employee’s network_id. last 4 digits of network id same last 4 digits of 1 of phone number employee. issue if person has 2 phone numbers meeting first criteria - substr(phone_number, length(phone_number)-3, 4) = substr('dp2543',3, 4) ),then in error out saying single row sub query returns more 1 row. know how can fix this? here code phone_numbers:-

select (decode((select distinct  phone_number per_phones    employee_id = 26022         , substr(phone_number, length(phone_number)-3, 4) = substr('dp2543',3, 4) ), null, (select distinct phone_number per_phones    employee_id =  26022  , phone_type = 'h1'),(select distinct phone_number per_phones    employee_id =  26022         , rownum=1) )  ) dual 

if don't care 1 pick, add top 1 in subquery

select top 1 phone_number [etc, etc...] 

if care, end subquery order by

select top 1 phone_number [etc, etc...] order phone_number 

Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -