> > >

Microsoft SQL Server MCQs

In which context is the ROW_NUMBER() function valid?

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();

Answer

Correct Answer: select ... ROW_NUMBER() over (partition by [group_val] order by [id]) as [row] ...;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it