Use variable with TOP in select statement in SQL Server without making it dynamic?

Question

declare @top int set @top = 5 select top @top * from tablename Is it possible? Or any idea for such a logic (i don't want to use dynamic query)?

Answer 1

Have you tried something like

DECLARE @rowcutoff int

SET @rowcutoff = 5

SELECT * FROM sometable WHERE ROW_NUMBER <= @rowcutoff;