How to select only Double Data to display on Ms. Sql Server
1/ Photo
2/ Coding
SELECT CustomerID,CustomerName,Phone
FROM dbo.tab_AR_Customer
WHERE CustomerID like'%KHV88%'
AND Phone IN
(SELECT Phone FROM dbo.tab_AR_Customer
WHERE CustomerID like'%KHV88%' and Phone<>'0' and Phone<>''
GROUP BY Phone having count(Phone) > 1)
Order by Phone
0 comments: