Filter posts by Category Or Tag of the Blog section!

Creating table in SQL using group by

Monday, 16 June 2014

I was just playing with SQL queries as It's for a long time I haven't write T-SQL code. I came into an error while creating a table via group by. Look at the following piece of code:


create table MyTable as
    select id, sum(number) as numbers
   from AnotherTable
   group by id


The above code doesn't work. One of the solutions that I found is using Insert Into like below:


select id,sum(number) as numbers
INTO MyTable
from AnotherTable
group by id


that's all!

Category: Data

Tags: Sql Server

comments powered by Disqus