How to find the row table in the view

WITH OrderedView AS (
    SELECT 
        *,
        ROW_NUMBER() OVER (ORDER BY ) AS RowNum
    FROM
        your_view_name
),
UnwantedRow AS (
    SELECT *
    FROM OrderedView
    WHERE Storename = 'Branch Name' AND TotalPrice IS NULL
)
SELECT
    UnwantedRow.*,
    PreviousRow.*,
    NextRow.*
FROM
    UnwantedRow
LEFT JOIN OrderedView AS PreviousRow ON UnwantedRow.RowNum = PreviousRow.RowNum + 1
LEFT JOIN OrderedView AS NextRow ON UnwantedRow.RowNum = NextRow.RowNum - 1;

This query will return the unwanted row along with the previous row and next row in the ordered view. The LEFT JOINs are used to find the corresponding rows based on the RowNum.

Remember to replace with the appropriate column name to order the rows correctly. Additionally, replace your_view_name with the name of your view.