select sno,sname,sex from (select ROW_NUMBER() over(order by sno) n,sno,sname,sex from persons) x where n%2=1
这里的 (select ROW_NUMBER() over(order by sno) n,sno,sname,sex from persons) x不理解什么原理顺序,大神帮帮忙
...全文
57512打赏收藏
SQL语句不理解,帮忙解释一下
select sno,sname,sex from (select ROW_NUMBER() over(order by sno) n,sno,sname,sex from persons) x where n%2=1 这里的 (select ROW_NUMBER() over(order by sno) n,sno,sname,sex from persons) x不理解什么原理顺序,大神帮帮忙