pratikshir says:
create table DemoTbl as (select * from TableName where filedName)
It’s not right way to create the table using this syntax. If you need to create new table from existing table with same table structure then refer the below test query.
SQL
SELECT *
INTO DemoTbl
FROM TableName
where filedName = ? -- Your condition value
-- or for perticulare column
SELECT [youecolumn1Name],[youecolumn2Name]
INTO DemoTbl
FROM TableName
where filedName = ? -- Your condition value