how to select top row from a variable using sql server 2008?

Question

Can we select top rows from variable value In sql server 2008?.like this.

    declare @rows int=2;
    select top @rows * from table_name;
-- instead of select top 2 * from table_name;

When you use TOP you also need to specify ORDER BY. Otherwise you have no way to ensure which rows will be returned. — Sean Lange
– Sean Lange, Commented Nov 30, 2016 at 14:37

John Cappelletti · Accepted Answer · 2016-11-30 13:10:55Z

3

You were almost there.

declare @rows int=2;
select top (@rows) * from table_name;

answered Nov 30, 2016 at 13:10

John Cappelletti

82.3k7 gold badges50 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Husen · Accepted Answer · 2016-11-30 13:13:51Z

0

You can also try this one.

declare @rows int=2;
declare @query varchar(200)= 'select top ' + cast(@rows as varchar(4))+ ' * from TBLB_Order';
exec (@query);

answered Nov 30, 2016 at 13:13

Husen

1,58510 silver badges14 bronze badges

BOUALI ALI · Accepted Answer · 2016-11-30 13:19:07Z

0

declare @rows int=2;
select top @rows percent * from table_name;

answered Nov 30, 2016 at 13:19

BOUALI ALI

2302 silver badges14 bronze badges