SQL Server TOP A to B

[NOTE]SQL Server TOP A to B

如何選擇性查詢哪一個區間的資料

Step 1:

設定row_number extract between A and B

 Step 2:

正序TOP30->倒序TOP10 = 20~30

Reference :

https://makyru.wordpress.com/2014/10/23/%E7%AD%86%E8%A8%98-%E9%99%90%E5%88%B6sql%E7%9A%84%E5%9B%9E%E5%82%B3%E8%B3%87%E6%96%99%E7%AD%86%E6%95%B8/