select no=identity(int,1,1),c_name into #temptable from cakeinfoselect * from #temptable where no>5drop table #temptable Select no=Identity(int,1,1),* Into #temptable From TableName --Order By SortFieldSelect * From #temptable --Where no>=6 And no < 10Drop Table #temptable