Clay Icon
Join the Community
02 Support

How to Copy Data from One Table to Another in SQL

Avatar of Josephine V.Josephine V.
·
·

i have a list of 1060 accounts, i want to get 11 of them into a new table, how do i copy the data exactly as is into another table?

2 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Here's how you can copy 11 specific accounts to a new table: 1. First, use filters in your current table to select just the 11 accounts you want to copy. 2. Then, use the Write to Table integration to transfer the data: • Click "Add Enrichment" in the top right corner • Search for and select "Write to Table" • Select your destination table • Map the columns you want to copy to maintain the exact data structureThis method will ensure all your selected data is copied exactly as is to the new table. Sources: Write to table integration overview | Documentation | Clay University Customize your table view | Documentation | Clay University

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Josephine V.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: