مساعدة يا شباب بتعليمة Select

على أساس أي شرط؟

select top 5 from TableName

ممكن نجرب الكود ده طبعا مع اختلاف اسماء Tables and columns

ان شاء الله يكون مفيد وتلاقي فيه الحل

declare @ID varchar(20),@username varchar(20)
declare @cunt as int
select @cunt = 1
Declare X Cursor for  
 	select CourseID, username from students
open x

fetch next from x into   @ID , @username
  while @@fetch_status <> -1 
  begin  
if @cunt between 1 and 5 
begin
 insert into table1 values ( @ID , @username )
end
if @cunt between 6 and 10 
begin
 insert into table2 values ( @ID , @username )
end
if @cunt between 11 and 15 
begin
 insert into table3 values ( @ID , @username )
end
select @cunt = @cunt +1
fetch next from x into 	@ID , @username
  end  
  close x
  deallocate x