select count(*) from (select row_number()over(partition by housename order by sysdate) num from vHouse where buildid='3') where num=2
如上的 oracle 语法 转换成 sql server的怎么写??
...全文
2317打赏收藏
问一条SQL语句的转换
select count(*) from (select row_number()over(partition by housename order by sysdate) num from vHouse where buildid='3') where num=2 如上的 oracle 语法 转换成 sql server的怎么写??
select count(*)
from
(select row_number()over(partition by housename order by getdate())
num from vHouse where buildid='3') a
where num=2
谢谢各位,加个别名把sysdate改为getdate() 就行了