Fetch a pattern of data in SQL Server

Venkatesan Jayakantham
12y
2.6k
0
0

Blog

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