Select from x th row next y rows

This code will show rows from 17th and then next 3 ordered by name from table authors in database pubs. Table must have primary key and of course ordered column. You can change value 'from' in line 'SET ROWCOUNT 17' and value 'next' (how many rows)in line SELECT TOP 3. It is good to show […]

2004-10-21 (first published: )

182 reads

Blogs

Spark .NET - Spark ML TF-IDF

By

Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...

Daily Coping 7 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Publish ADF from code to further environments

By

Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good...

Read the latest Blogs

Forums

Help needed in checking dates spans and status

By dhanekulakalyan

Hello All, I have a requirement where we need to merge spans if the...

List of all OWNERS, not db_owner

By Footage

How can I get a list of all database owners in an instance (not...

Document recovery procedure

By Admingod

Trying to document a process in an event of disaster and different reasons. In...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers