what is a query for divide a table into two subtable?



what is a query for divide a table into two subtable?..

Answer / Rajeev Kumar Ranjan

To split a table into two subtables, you can use the SQL CREATE TABLE AS SELECT statement. Here's an example of how to create two new tables (NEW_TABLE1 and NEW_TABLE2) from an existing table (ORIGINAL_TABLE) based on specific conditions:nnCREATE TABLE NEW_TABLE1 AS nSELECT * FROM ORIGINAL_TABLE WHERE CONDITION1;nCREATE TABLE NEW_TABLE2 AS nSELECT * FROM ORIGINAL_TABLE WHERE CONDITION2;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Engineering AllOther Interview Questions

What is the angle of phase sequence.

1 Answers  


compare the conditional operator with if-else-if statement.

1 Answers  


Difference in NS and TIA type HRC fuses

1 Answers  


What is the difference between "type testing" and "product qualification"?

1 Answers  


Is there any difference between the concepts of encoding,decoding and encryption and decryption?

1 Answers  


wat is the process of civil services examination...I want to become DSP....Is civil services and APPSC are sam???first of all for wat we have to prepare...for prelimnary or for mains or for nterview...i dont know any thing...please help me...arun.kanduri@gmail.com

1 Answers  


Give a brief description of the following terms: a) Play head b) Symbol c) Tweening d) ActionScript e) Frame rate f) Library panel g) Masking h) Context – sensitive Property Inspector i) Bandwidth Profiler j) Frame Label

1 Answers  


how does data cleansing framework works?

1 Answers   TCS,


how to generate linked implementation of sparse matrix?

1 Answers  


why do you want to join tcs

1 Answers   TCS,


whether we can implement VPN based on UDP? If yes then tell how? If no tell why not?

1 Answers  


explain various problem solving statagis

1 Answers  


Categories
  • Civil Engineering Interview Questions Civil Engineering (5086)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4453)
  • Electrical Engineering Interview Questions Electrical Engineering (16638)
  • Electronics Communications Interview Questions Electronics Communications (3918)
  • Chemical Engineering Interview Questions Chemical Engineering (1095)
  • Aeronautical Engineering Interview Questions Aeronautical Engineering (239)
  • Bio Engineering Interview Questions Bio Engineering (96)
  • Metallurgy Interview Questions Metallurgy (361)
  • Industrial Engineering Interview Questions Industrial Engineering (259)
  • Instrumentation Interview Questions Instrumentation (3014)
  • Automobile Engineering Interview Questions Automobile Engineering (332)
  • Mechatronics Engineering Interview Questions Mechatronics Engineering (97)
  • Marine Engineering Interview Questions Marine Engineering (124)
  • Power Plant Engineering Interview Questions Power Plant Engineering (172)
  • Textile Engineering Interview Questions Textile Engineering (575)
  • Production Engineering Interview Questions Production Engineering (25)
  • Satellite Systems Engineering Interview Questions Satellite Systems Engineering (106)
  • Engineering AllOther Interview Questions Engineering AllOther (1379)