Count case when *
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am getting an error in my count case statement and I was hoping I could get some help.
My line of code is
count(case when product = 'classic' then * end)
and the error message that I am getting is
ERROR: syntax error at or near "*"
LINE 4: ...t(case when initial_product_line = 'classic' then * end) as ...
can I not do a count *?
^
sql amazon-redshift psql
edited Nov 16 '18 at 16:59
Yogesh Sharma
35k51440
asked Nov 16 '18 at 16:56
Steve PakSteve Pak
52
add a comment |
I am getting an error in my count case statement and I was hoping I could get some help.
My line of code is
count(case when product = 'classic' then * end)
and the error message that I am getting is
ERROR: syntax error at or near "*"
LINE 4: ...t(case when initial_product_line = 'classic' then * end) as ...
can I not do a count *?
^
sql amazon-redshift psql
edited Nov 16 '18 at 16:59
Yogesh Sharma
35k51440
asked Nov 16 '18 at 16:56
Steve PakSteve Pak
52
add a comment |
I am getting an error in my count case statement and I was hoping I could get some help.
My line of code is
count(case when product = 'classic' then * end)
and the error message that I am getting is
ERROR: syntax error at or near "*"
LINE 4: ...t(case when initial_product_line = 'classic' then * end) as ...
can I not do a count *?
^
sql amazon-redshift psql
edited Nov 16 '18 at 16:59
Yogesh Sharma
35k51440
asked Nov 16 '18 at 16:56
Steve PakSteve Pak
52
I am getting an error in my count case statement and I was hoping I could get some help.
My line of code is
count(case when product = 'classic' then * end)
and the error message that I am getting is
ERROR: syntax error at or near "*"
LINE 4: ...t(case when initial_product_line = 'classic' then * end) as ...
can I not do a count *?
^
sql amazon-redshift psql
sql amazon-redshift psql
edited Nov 16 '18 at 16:59
Yogesh Sharma
35k51440
asked Nov 16 '18 at 16:56
Steve PakSteve Pak
52
edited Nov 16 '18 at 16:59
Yogesh Sharma
35k51440
asked Nov 16 '18 at 16:56
Steve PakSteve Pak
52
edited Nov 16 '18 at 16:59
Yogesh Sharma
35k51440
edited Nov 16 '18 at 16:59
Yogesh Sharma
35k51440
edited Nov 16 '18 at 16:59
Yogesh Sharma
35k51440
35k51440
asked Nov 16 '18 at 16:56
Steve PakSteve Pak
52
asked Nov 16 '18 at 16:56
Steve PakSteve Pak
52
asked Nov 16 '18 at 16:56
Steve PakSteve Pak
52
52
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
* has special meaning in SQL, you need either 1 or columnname instead :
count(case when product = 'classic' then col end)
You can also simplify it as :
sum(case when product = 'classic' then 1 else 0 end)
answered Nov 16 '18 at 16:57
Yogesh SharmaYogesh Sharma
35k51440
add a comment |
I normally use sum():
sum(case when product = 'classic' then 1 else 0 end)
Amazon Redshift doesn't support the latest Postgres functionality, but Postgres implements the filter clause, which is nice:
count(*) filter (where product = 'classic')
I just bring this up because it is standard syntax and related to your version of the query (and supported by a related database).
answered Nov 16 '18 at 16:57
Gordon LinoffGordon Linoff
797k37318423
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53342275%2fcount-case-when%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
* has special meaning in SQL, you need either 1 or columnname instead :
count(case when product = 'classic' then col end)
You can also simplify it as :
sum(case when product = 'classic' then 1 else 0 end)
answered Nov 16 '18 at 16:57
Yogesh SharmaYogesh Sharma
35k51440
add a comment |
* has special meaning in SQL, you need either 1 or columnname instead :
count(case when product = 'classic' then col end)
You can also simplify it as :
sum(case when product = 'classic' then 1 else 0 end)
answered Nov 16 '18 at 16:57
Yogesh SharmaYogesh Sharma
35k51440
add a comment |
* has special meaning in SQL, you need either 1 or columnname instead :
count(case when product = 'classic' then col end)
You can also simplify it as :
sum(case when product = 'classic' then 1 else 0 end)
answered Nov 16 '18 at 16:57
Yogesh SharmaYogesh Sharma
35k51440
* has special meaning in SQL, you need either 1 or columnname instead :
count(case when product = 'classic' then col end)
You can also simplify it as :
sum(case when product = 'classic' then 1 else 0 end)
answered Nov 16 '18 at 16:57
Yogesh SharmaYogesh Sharma
35k51440
answered Nov 16 '18 at 16:57
Yogesh SharmaYogesh Sharma
35k51440
answered Nov 16 '18 at 16:57
Yogesh SharmaYogesh Sharma
35k51440
answered Nov 16 '18 at 16:57
Yogesh SharmaYogesh Sharma
35k51440
35k51440
add a comment |
add a comment |
I normally use sum():
sum(case when product = 'classic' then 1 else 0 end)
Amazon Redshift doesn't support the latest Postgres functionality, but Postgres implements the filter clause, which is nice:
count(*) filter (where product = 'classic')
I just bring this up because it is standard syntax and related to your version of the query (and supported by a related database).
answered Nov 16 '18 at 16:57
Gordon LinoffGordon Linoff
797k37318423
add a comment |
I normally use sum():
sum(case when product = 'classic' then 1 else 0 end)
Amazon Redshift doesn't support the latest Postgres functionality, but Postgres implements the filter clause, which is nice:
count(*) filter (where product = 'classic')
I just bring this up because it is standard syntax and related to your version of the query (and supported by a related database).
answered Nov 16 '18 at 16:57
Gordon LinoffGordon Linoff
797k37318423
add a comment |
I normally use sum():
sum(case when product = 'classic' then 1 else 0 end)
Amazon Redshift doesn't support the latest Postgres functionality, but Postgres implements the filter clause, which is nice:
count(*) filter (where product = 'classic')
I just bring this up because it is standard syntax and related to your version of the query (and supported by a related database).
answered Nov 16 '18 at 16:57
Gordon LinoffGordon Linoff
797k37318423
I normally use sum():
sum(case when product = 'classic' then 1 else 0 end)
Amazon Redshift doesn't support the latest Postgres functionality, but Postgres implements the filter clause, which is nice:
count(*) filter (where product = 'classic')
I just bring this up because it is standard syntax and related to your version of the query (and supported by a related database).
answered Nov 16 '18 at 16:57
Gordon LinoffGordon Linoff
797k37318423
answered Nov 16 '18 at 16:57
Gordon LinoffGordon Linoff
797k37318423
answered Nov 16 '18 at 16:57
Gordon LinoffGordon Linoff
797k37318423
answered Nov 16 '18 at 16:57
Gordon LinoffGordon Linoff
797k37318423
797k37318423
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53342275%2fcount-case-when%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
