Insert The Result Of A Select Query Example

insert into mytable

select 2012,courseno,termno from mytable

where year=2011

Advertisements