Monday, 12 November 2012

How to copy particular records into another table


How to copy particular records into another table ?                
 select * into temptabbb from 
(
 select ROW_NUMBER() over(order by salery) as rownum,EmpName,EmpNo from EmployeeRecord) tempderivedtable 
 where rownum>5               

No comments:

Post a Comment