This will work.
declare @columnname as varchar(500)
declare @tablename as varchar(500)
declare @Columnindex as int
declare @query as nvarchar(max)
set @tablename='attendance2'
set @Columnindex=1
select @columnname= COLUMN_NAME from INFORMATION_SCHEMA.Columns
where ORDINAL_POSITION=@Columnindex and TABLE_NAME=@tablename
set @query='select ' + @columnname +' From '+@tablename
exec sp_executesql @query