partition by

Question

partition by

Vineet S 1,390

Hi,

how to add partition by in below table where there is no date key or duration..please give example

here is example of sample data

customerid - 1

product - grains

productcategory-rice

sales- 1000

Erland Sommarskog 134K Reputation points MVP Volunteer Moderator

2024-11-20T22:12:03.4133333+00:00

May I kindly remind you that this is a technical forum for peer support, and not a training camp for ladies with crystal balls?

Please clarify your question, so that we can understand your problem. For instance, provide CREATE TABLE statement for your table(s), INSERT statements with sample data, and the desired result given the test data, together with a brief explanation why you want that result.

Vineet S 1,390

create table product(customerid  varchar(20), product varchar(20),productcategory varchar(20), sales Integer);

DECLARE @counter INT=1;
WHILE @counter <=1000
BEGIN
  insert into product (customerid ,product,productcategory)
values('1','grain','rice',1000)
SET @counter=counter +1

END

Answer accepted by question author

0 additional answers

Your answer

Erland Sommarskog 134K Reputation points MVP Volunteer Moderator

2024-11-20T22:12:03.4133333+00:00

May I kindly remind you that this is a technical forum for peer support, and not a training camp for ladies with crystal balls?

Please clarify your question, so that we can understand your problem. For instance, provide CREATE TABLE statement for your table(s), INSERT statements with sample data, and the desired result given the test data, together with a brief explanation why you want that result.
Vineet S 1,390 Reputation points

2024-11-21T02:13:36.1866667+00:00

create table product(customerid varchar(20), product varchar(20),productcategory varchar(20), sales Integer); DECLARE @counter INT=1; WHILE @counter <=1000 BEGIN insert into product (customerid ,product,productcategory) values('1','grain','rice',1000) SET @counter=counter +1 END

Answer 1

Hi @Vineet S

how to add partition by in below table where there is no date key or duration..please give example

If you mean using PARTITION BY in Windows Functions, then the key is to choose a column (or columns group) that makes sense for dividing your data into groups. You don’t need a date or duration column to partition the data. For example, you can partition by product or productcategory.

If you mean creating partitioned table where there is no date key or duration, you can still partition by other columns that makes sense for your data.

For example, you could partition by different product types, like foods, clothes, appliances...

Or partition by the range of sales, like 0~500 belongs to partition1, 501~1000 belongs to partition2...

For more details, review this doc: Create partitioned tables and indexes.

Also, see these two articles for more examples: Database table partitioning in SQL Server; SQL Server Table Partitioning.

Best regards,

Cosmog

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Share via

partition by

0 additional answers

Your answer