sql
server擷取指定行(如第二行)的資料
--sql
server擷取指定行(如第二行)的資料--
--法一(對象法)--
select
* from
(
* , number = row_number() over(order
by
grade desc) from students
) m
where number = 2
--法二(排除法)---
top 1 * from students
where
grade not in
top 1 grade from students
)
![在DOS下運作不了ipconfig指令[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)