在SQL Server中,ROW_NUMBER()函数在哪种情况下有效?( )
select ... inner join [tbl] on ROW_NUMBER() = [tbl].[id];
select ... ROW_NUMBER() over (partition by [group_val] order by [id]) as [row] ...;
select ... ROW_NUMBER() as [row] ... group by [group_val] order by [id];
select ROW_NUMBER();