Get DISTINCT OwnerID

[FengShui1998]

Hello,

I have a table with multiple entries for devices where the DEVTYPE = 'iPad' or DEVTYPE = 'iPhone' and each record has the OwnerID. An owner can have multiple records.
I'd like to pull just the OwnerID whether they have and iPad or an iPhone. I am using DISTINCT however it's returning all the records for an owner.

Thanks ahead of time.

fengshui1998

 

[r937]

if you want to pull just the OwnerID, then do not include any other columns after the keyword DISTINCT

SELECT DISTINCT OwnerID FROM daTable

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[FengShui1998]

I understand that, but I want to exclude other devtypes like devtype=blackberry or devtype=windowsphone.

Thanks.

 

[r937]

SELECT DISTINCT OwnerID 
  FROM daTable 
 WHERE devtype IN ( 'iPad' , 'iPhone' )

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon