putting 1 lakh rows in 15 tables from a table having 15 lakh rows

there are 15 lakh records in a table. i want to create 15 tables with 1lakh rows in each table. is there any possibility by using select top 100000 into new table from original table and then select top 100001 to 200000 in to new table from original table. please guide how i can manage this

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sand143eep commented · Nov 13, 2019 at 05:10 AM

we cant use where condition here, due to which I am struggling

0 ·

ThomasRushton ♦♦ commented · Nov 13, 2019 at 08:26 AM

select / offset / fetch - https://docs.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql?view=sql-server-ver15#using-offset-and-fetch-to-limit-the-rows-returned - although it may be SQL 2012 onwards.

0 ·

Mark_H_Thornton commented · Nov 13, 2019 at 11:24 AM

For those who don't know, 1 lakh = 100,000 (https://en.wikipedia.org/wiki/Lakh)

0 ·

Jeff Moden commented · Nov 15, 2019 at 04:54 AM

You ask for help but only give use a couple of numbers with no details. Post the DDL for the source table and tell us what naming pattern you want for the 15 tables and what we should do an ORDER BY on to control the order. Also let us know which version of SQL Server you're actually working with... you have both 2008R2 AND 2012 selected as tags.

0 ·

sand143eep commented · Nov 19, 2019 at 04:24 AM

A Thomas and ananth suggested used the limit and offset as follows:

SELECT employee_id,first_name,last_name FROM employees ORDER BYfirst_name LIMIT5OFFSET3;

which gave me required results. thanks for help.

0 ·