Breaking News: Grepper is joining You.com. Read the official announcement!

SQL paging using ROW_NUMBER()

Mahesh Kumar Yadav answered on September 5, 2023 Popularity 1/10 Helpfulness 1/10

answer SQL paging using ROW_NUMBER()

SQL paging using ROW_NUMBER()

Comment

WITH x
     AS (SELECT k = Row_number()
                      OVER (
                        ORDER BY handle_id),
                handle_class,
                handle_id,
                object_title,
                object_create_date,
                object_modified_date,
                class_name,
                handle_index
         FROM   docushare.dbo.dsobject_table
                JOIN docushare.dbo.class_def_table lt
                  ON docushare.dbo.dsobject_table.handle_class = lt.class_id
         WHERE  object_isdeleted = 0
                AND handle_class = 1
                AND object_title IN (SELECT 'Personal Collection for' + ' '
                                            + user_username
                                     FROM   docushare.dbo.dsobject_table
                                     WHERE  user_isactive = 1
                                            AND collection_emailalias <>
                                                'anonymous')
        )
SELECT *
FROM   x
WHERE  k BETWEEN 1 AND 100

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: function pagination paging row-number sql sql-server using

Link to this answer
Share Copy Link

Contributed on Sep 05 2023

Mahesh Kumar Yadav

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

SQL paging using ROW_NUMBER()

Contents

More Related Answers

SQL paging using ROW_NUMBER()

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.