sql - 这可以在一个sql查询中完成吗？

Question

根据字段名称建立索引的表

对于名称“name1”的给定值，给我该行以及之前的 N 行和之后的 N 行(按字母顺序)

Answer 1

是否在两个 select 语句中将数字 5 替换为您想要的 N 并更改表名称，这样就可以了。还要用正确的列名称替换星号。如果您对此有任何问题，请告诉我。

  select * from 
    (
        Select *
        ,row_number() over (order by firstname desc) as 'rowNumber'
        from attendees
    ) as temp
where rowNumber between 
 (
    select rownumber-1 
    from 
        (
            Select *, row_number() over (order by firstname desc) as 'rowNumber'
            from attendees
        ) as temp
    where firstname = 'name1')  AND (
    select rownumber+1 
    from 
        (
            Select *, row_number() over (order by firstname desc) as 'rowNumber'
            from attendees
        ) as temp
    where firstname = 'name1')