单选题

数据库中有一表students(first_name, last_name...

Question

数据库中有一表students(first_name, last_name, gender, age), 下面那条SQL语句可以实现现有数据的拷贝？(  )

A. insert into students(first_name, last_name, gender, age) select first_name,last_name,gender, age from students 

B. insert into students(first_name, last_name, gender, age) values(select first_name,last_name,gender, age from students) 

C. insert into students(first_name, last_name, gender, age) values in  (select first_name,last_name,gender, age from students) 

D. insert into students(first_name, last_name, gender, age) with (select first_name,last_name,gender, age from students)