SQL insert with select

This is possible to copy the table data from one table to another by using the SQL Insert into with select statement.
The insert into statement specifies the table where data needs to be copied. Whereas the select specifies where data should be copied from.