Friday, September 29, 2017

Select only Double Data to display [Ms-SQL Server]

by Unknown  |  in Ms. SQL Server Trick at  4:08 PM

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:

Proudly Powered by Blogger.