rjk1203

 Profile Answers by rjk1203 Questions by rjk1203

• Sep 15th, 2008

 

It can be done by create / insert statement as follows ;

   If 'EMP' is the table with structure

   ENO          VarChar(12)
   DoJ           date
   ESAL         Numerix
   COMM       numeric 

   Now , we can create EMP1 table using EMP Table and exclude the field 'COMM' as

    create table EMP1 as select ENO, DoJ, ESAL from EMP where 1<0 ( this false condition will copy the structure only , not rows from EMP table)

vishnu vardhan reddy

 Profile Answers by vishnu vardhan reddy 

• Sep 16th, 2008

 

create table  tablename as select * from emp where 1=2
only table structure will be copied

vishnu vardhan reddy

 Profile Answers by vishnu vardhan reddy 

• Sep 16th, 2008

 

select e.* from(select ename,sal, dense_rank() over(order by sal desc) ranksal from emp)e where e.ranksal=2

patilpravin_1981

 Profile Answers by patilpravin_1981 

• Sep 25th, 2008

 

create table_name
as select coulmn_name from table_name;

jandhyala.aparna

 Profile Answers by jandhyala.aparna 

• Sep 26th, 2008

 

CREATE TABLE emp1 AS (SELECT empno, ename, hiredate, sal
                                    FROM emp);

GENERAL SYSTAX :

CREATE TABLE <table name> AS (SELECT <column list that you wish to include>
                                                     FROM <existing table name>
                                                     [WHERE] <condition> );
where clause is optional.

                                   

nathsambu

 Profile Answers by nathsambu 

• Dec 19th, 2008

 

create table emp1 as select * from emp;

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

CREATE TABLE emp1 AS (SELECT empno, ename, hiredate, s