select query without Identity column

Question

i want to create a select query, in the query i want to select all data in the table except identity colums data.

How it possible?

this is for that i want to insert all tha data from one table to another, here two table has identity column.