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
Post a Comment