Double results when select SQL query [duplicate]

Question

I've tried to fix that by my self but I couldn't find any solution so maybe you can help. I have following query:

select users.name,users.userid,position,department.name,num,phone.pname,objpict.fname 
from users 
inner join opict on opict.ownerid=users.id 
inner join department on department.id=users.deptid
inner join phone on phone.ownerid=users.id 
where quitted=0 and tag='web' and opict.del=0 and phone.del=0 and phone.ownertype=5

It's working great but the problem is that some users have 2 or 3 diffrent nummbers so select resoult will be:

Name     UserID   Number
------   ------   --------
David    Test     12345678
David    Test     11111111

So the problem is that output will be double. How can I fix that it will be formatted like this:

Name     UserID   Number
------   ------   --------
David    Test     12345678
         Test     11111111

Answer 1

If you don't want to display duplicate values you can make use of ROW_NUMBER() along with a CASE statement:

select case
           when row_number() over (partition by users.userId order by users.userId) = 1
               then users.name
           else NULL
        end as userName
    , users.userid
    , position
    , department.name
    , num
    , phone.pname
    , objpict.fname
from users
inner join opict
    on opict.ownerid = users.id
inner join department
    on department.id = users.deptid
inner join phone
    on phone.ownerid = users.id
where quitted = 0
    and tag = 'web'
    and opict.del = 0
    and phone.del = 0
    and phone.ownertype = 5

If you don't want NULL to be displayed and want a "white space" you can change the second branch of the CASE statement to else ''.