troubleshooting Question

Spliting result sql statement

Avatar of MetDia
MetDia asked on
Microsoft SQL Server 2005
6 Comments1 Solution224 ViewsLast Modified:

I need to find a way to split a select in 2 or more grouping in a sql statement.

For exemple, I have one select with 1000 lines and i need to split those lines in 3. The first 500 (1 to 500) and then 250 (501 to 750) and the last 250 (751 to 1000). I need that in a sql statement.

It's TSQL and  I'm using microsoft sql server, a prior versions, not the 2005

Any thoughts on how to do this?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros