Mixing
Sql count() for two parameters
-1
How do I get count for two parameters for the following set:
beds : 2, classRate : 3
beds : 2, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 4
beds : 4, classRate : 4
beds : 4, classRate : 4
The result set should be:
beds : 2, classRate : 3, count :2
beds : 4, classRate : 3, count :4
beds : 4, classRate : 4, count :3
sql count mariadb
asked Jan 1 at 14:16
a_chubenkoa_chubenko
4816
add a comment |
-1
How do I get count for two parameters for the following set:
beds : 2, classRate : 3
beds : 2, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 4
beds : 4, classRate : 4
beds : 4, classRate : 4
The result set should be:
beds : 2, classRate : 3, count :2
beds : 4, classRate : 3, count :4
beds : 4, classRate : 4, count :3
sql count mariadb
asked Jan 1 at 14:16
a_chubenkoa_chubenko
4816
2
Hint:GROUP BY.
– Gordon Linoff
Jan 1 at 14:18
add a comment |
-1
-1
-1
How do I get count for two parameters for the following set:
beds : 2, classRate : 3
beds : 2, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 4
beds : 4, classRate : 4
beds : 4, classRate : 4
The result set should be:
beds : 2, classRate : 3, count :2
beds : 4, classRate : 3, count :4
beds : 4, classRate : 4, count :3
sql count mariadb
asked Jan 1 at 14:16
a_chubenkoa_chubenko
4816
How do I get count for two parameters for the following set:
beds : 2, classRate : 3
beds : 2, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 3
beds : 4, classRate : 4
beds : 4, classRate : 4
beds : 4, classRate : 4
The result set should be:
beds : 2, classRate : 3, count :2
beds : 4, classRate : 3, count :4
beds : 4, classRate : 4, count :3
sql count mariadb
sql count mariadb
asked Jan 1 at 14:16
a_chubenkoa_chubenko
4816
asked Jan 1 at 14:16
a_chubenkoa_chubenko
4816
asked Jan 1 at 14:16
a_chubenkoa_chubenko
4816
asked Jan 1 at 14:16
a_chubenkoa_chubenko
4816
asked Jan 1 at 14:16
a_chubenkoa_chubenko
4816
4816
2
Hint:GROUP BY.
– Gordon Linoff
Jan 1 at 14:18
add a comment |
2
Hint:GROUP BY.
– Gordon Linoff
Jan 1 at 14:18
2
2
Hint:
GROUP BY.– Gordon Linoff
Jan 1 at 14:18
Hint:
GROUP BY.– Gordon Linoff
Jan 1 at 14:18
add a comment |
3 Answers
3
active
oldest
votes
2
suppose that you have Table1 with (beds, classrates) columns then,
select beds, classrates, count(*) from table1
group by beds, classrates
would to what you need
answered Jan 1 at 14:26
SimonareSimonare
15k11840
add a comment |
0
SELECT CLASS_RATE, BEDS, COUNT(*) AS CC FROM ROOMS
WHERE (CLASS_RATE >= ? AND CLASS_RATE <= ?) GROUP BY CLASS_RATE, BEDS
answered Jan 1 at 14:28
a_chubenkoa_chubenko
4816
It looks like your post is mostly code, please add some more details
– Simonare
Jan 1 at 16:20
add a comment |
-1
select beds, classrates, count(*) from table1 group by beds, classrates
Try this. Count(*) will return counting of result.
answered Jan 1 at 14:26
Amit GandoleAmit Gandole
707
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
});
}
});
draft saved
draft discarded
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%2f53996186%2fsql-count-for-two-parameters%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
2
suppose that you have Table1 with (beds, classrates) columns then,
select beds, classrates, count(*) from table1
group by beds, classrates
would to what you need
answered Jan 1 at 14:26
SimonareSimonare
15k11840
add a comment |
2
suppose that you have Table1 with (beds, classrates) columns then,
select beds, classrates, count(*) from table1
group by beds, classrates
would to what you need
answered Jan 1 at 14:26
SimonareSimonare
15k11840
add a comment |
2
2
2
suppose that you have Table1 with (beds, classrates) columns then,
select beds, classrates, count(*) from table1
group by beds, classrates
would to what you need
answered Jan 1 at 14:26
SimonareSimonare
15k11840
suppose that you have Table1 with (beds, classrates) columns then,
select beds, classrates, count(*) from table1
group by beds, classrates
would to what you need
answered Jan 1 at 14:26
SimonareSimonare
15k11840
answered Jan 1 at 14:26
SimonareSimonare
15k11840
answered Jan 1 at 14:26
SimonareSimonare
15k11840
answered Jan 1 at 14:26
SimonareSimonare
15k11840
15k11840
add a comment |
add a comment |
0
SELECT CLASS_RATE, BEDS, COUNT(*) AS CC FROM ROOMS
WHERE (CLASS_RATE >= ? AND CLASS_RATE <= ?) GROUP BY CLASS_RATE, BEDS
answered Jan 1 at 14:28
a_chubenkoa_chubenko
4816
It looks like your post is mostly code, please add some more details
– Simonare
Jan 1 at 16:20
add a comment |
0
SELECT CLASS_RATE, BEDS, COUNT(*) AS CC FROM ROOMS
WHERE (CLASS_RATE >= ? AND CLASS_RATE <= ?) GROUP BY CLASS_RATE, BEDS
answered Jan 1 at 14:28
a_chubenkoa_chubenko
4816
It looks like your post is mostly code, please add some more details
– Simonare
Jan 1 at 16:20
add a comment |
0
0
0
SELECT CLASS_RATE, BEDS, COUNT(*) AS CC FROM ROOMS
WHERE (CLASS_RATE >= ? AND CLASS_RATE <= ?) GROUP BY CLASS_RATE, BEDS
answered Jan 1 at 14:28
a_chubenkoa_chubenko
4816
SELECT CLASS_RATE, BEDS, COUNT(*) AS CC FROM ROOMS
WHERE (CLASS_RATE >= ? AND CLASS_RATE <= ?) GROUP BY CLASS_RATE, BEDS
answered Jan 1 at 14:28
a_chubenkoa_chubenko
4816
answered Jan 1 at 14:28
a_chubenkoa_chubenko
4816
answered Jan 1 at 14:28
a_chubenkoa_chubenko
4816
answered Jan 1 at 14:28
a_chubenkoa_chubenko
4816
4816
It looks like your post is mostly code, please add some more details
– Simonare
Jan 1 at 16:20
add a comment |
It looks like your post is mostly code, please add some more details
– Simonare
Jan 1 at 16:20
It looks like your post is mostly code, please add some more details
– Simonare
Jan 1 at 16:20
It looks like your post is mostly code, please add some more details
– Simonare
Jan 1 at 16:20
add a comment |
-1
select beds, classrates, count(*) from table1 group by beds, classrates
Try this. Count(*) will return counting of result.
answered Jan 1 at 14:26
Amit GandoleAmit Gandole
707
add a comment |
-1
select beds, classrates, count(*) from table1 group by beds, classrates
Try this. Count(*) will return counting of result.
answered Jan 1 at 14:26
Amit GandoleAmit Gandole
707
add a comment |
-1
-1
-1
select beds, classrates, count(*) from table1 group by beds, classrates
Try this. Count(*) will return counting of result.
answered Jan 1 at 14:26
Amit GandoleAmit Gandole
707
select beds, classrates, count(*) from table1 group by beds, classrates
Try this. Count(*) will return counting of result.
answered Jan 1 at 14:26
Amit GandoleAmit Gandole
707
edited Jan 3 at 2:20
answered Jan 1 at 14:26
Amit GandoleAmit Gandole
707
answered Jan 1 at 14:26
Amit GandoleAmit Gandole
707
answered Jan 1 at 14:26
Amit GandoleAmit Gandole
707
707
add a comment |
add a comment |
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53996186%2fsql-count-for-two-parameters%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
2
Hint:
GROUP BY.– Gordon Linoff
Jan 1 at 14:18