Fetch a pattern of data in SQL Server

Fetch a pattern of data:

      Consider, If you want to fetch a specific pattern of data like I want to fetch customerkey which are able to divide by 100. A pattern of divide of 100 values.
In that case, the query created is as below.

SELECT TOP 1000 [CustomerKey]

,[GeographyKey]
,[CustomerAlternateKey]
,[Phone]
,[DateFirstPurchase]
,[CommuteDistance]
FROM [dbo].[DimCustomer] 
where (CustomerKey % 100 =0)

Cheers,
Venkatesan Prabu .J
www.kaashivinfotech.com
Ebook Download
View all
Learn
View all