Technical Article

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 […]

You rated this post out of 5. Change rating

2004-10-21 (first published: )

203 reads

Blogs

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

By

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...

Understanding Fabric MCP

By

Model Context Protocol, or MCP, is one of those technical ideas that sounds more...

AWS RDS Aurora - our first approach

By

When starting with AWS RDS Aurora for managing relational databases in the cloud, many...

Read the latest Blogs

Forums

Alamat kantor resmi BCA KCU BEKASI Telp:0817.62.9933

By layanan0014

WhatsApp:0817629933 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...

BCA KCP Sahid Sudirman Residence TLP/WA 08216977749

By amzoptimizer123@gmail.com

The Office Sahid Sudirman Residence, Jl. Jenderal Sudirman No.86 Lt. LG Unit 01, Karet...

BCA KCP Mangga Besar VIII TLP/WA 08216366654

By amzoptimizer123@gmail.com

Jl. Mangga Besar VIII, BB CC No.11, Daerah Khusus Ibukota Jakarta 11150

Visit the forum

Question of the Day

May the Fourth Be With You Fun

In honor of May the fourth and Star Wars (may the force be with you), finish this quote:

"Do, or do not.  ..."

See possible answers