Creating one table from select query in SQL [duplicate]

Question

  Select    
    Books.IdBooks,
    Books.Title,
    Books.Author,
    COUNT(Books.IdBooks) as NumberOfOrderedBooks

    From Books
    right join Orders
      on (Books.IdBooks = Orders.IdBooks)
    group by
        Books.IdSeminar,
        Books.Naziv

This select query works fine, but I would like to create table from this query in SQL 2012, and I dont know how to do that.

Thanks in advance

Elliott Frisch · Accepted Answer · 2014-06-24 18:18:40Z

1

If I understand you, you can use a INTO CLAUSE like so,

Select    
  Books.IdBooks,
  Books.Title,
  Books.Author,
  COUNT(Books.IdBooks) as NumberOfOrderedBooks
Into NEW_TABLE
From Books
right join Orders
  on (Books.IdBooks = Orders.IdBooks)
group by
    Books.IdSeminar,
    Books.Naziv

answered Jun 24, 2014 at 18:18

Elliott Frisch

202k20 gold badges166 silver badges265 bronze badges

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

1 Comment

durbnpoisn Over a year ago

Beat me to the punch by like 4 seconds

Collectives™ on Stack Overflow

Creating one table from select query in SQL [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related