Save query in table in SQL

Question

I have a simple SQL query that look like this

select distinct v.col1, v.col2, v.col3
from table v
where v.col1 is not null

I would like to save the result set returned from this query into a completely new table called test.

How can I do that?

Thank you

If i understand you, you can use SELECT .... INTO .... FROM.... But if you want up to date values try with views — Marko Ivkovic
– Marko Ivkovic, Commented Apr 20, 2021 at 11:15

DonKnacki · Accepted Answer · 2021-04-20 11:14:23Z

1

you can create a view like that :

CREATE VIEW [View_name] AS
select distinct v.col1, v.col2, v.col3
from table v
where v.col1 is not null

answered Apr 20, 2021 at 11:13

DonKnacki

4274 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2021-04-20 11:15:58Z

0

The standard method to create a new table uses create table as:

create table new_table as
    select distinct v.col1, v.col2, v.col3
    from table v
    where v.col1 is not null;

Not all databases support this construct; for instance, SQL Server uses into:

select distinct v.col1, v.col2, v.col3
into new_table
from table v
where v.col1 is not null;

You may find that a view is sufficient, but a view is different from a table -- it is executed each time it is referenced.

answered Apr 20, 2021 at 11:15

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges