newbie SQL questions.

Sign In

Sign in to your account

If you are new here please register for an account

Username:

Password:

Запомнить меня

Забыли пароль?

Решено newbie SQL questions.

Hi, a simple group by question.

How to I get a table to group by month when having a dato field...

SELECT COUNT(*), month(dato) AS MND
FROM SALG
GROUP BY month(dato)

will not work because I'm not allowed to use expressions in group by...

Other SQL can, not Valentina... why or what is the workaraound...

Please help...

I also need to get week number of year grouping as well.

Комментарий

There are no comments made yet.

Ответы (2)

Ruslan Zasukhin Ответ принят

Notice: In Valentina 6.0 group by expression works already.

Комментарий

There are no comments made yet.

Sergey Pashkov Ответ принят

Hi, Helge

Here's how it can be done:

SELECT COUNT(*), MND
FROM ( SELECT month( dato ) AS MND FROM SALG )
GROUP BY MND

As for the second question, can you add details or a small example, please?

Комментарий

There are no comments made yet.

Страница :
1

There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Чтобы оставить ответ, необходимо зарегистрироваться

Вы должны быть зарегистрированы, чтобы иметь возможность оставить ответ. Водите, используя форму входа или зарегистрируйтесь, если вы впервые на сайте. Зарегистрируйтесь здесь »

Забыли пароль?

Решено newbie SQL questions.

Categories

Продукты

Поддержка

О Компании