SQL Query for Product table
-2
I ask this question for small model of my main table.
I have a table Product and I want a result table like this from a SQL query:
Color | existing Color count | existing sizes from this color
----------+------------------------+--------------------------------
red | 20 | 3
black | 12 | 4
Product table has [Id, Name, Color, Size, Price] columns.
I wrote this SQL statement:
SELECT
Color,
COUNT(Color) AS "numbers",
COUNT(Size) AS "sizes"
FROM
[Production].[Product]
GROUP BY
Color, Size;
sql-server tsql edited Nov 24 '18 at 7:18
marc_s
578k12911161261
asked Nov 23 '18 at 21:23
miladhpmiladhp
2618
|
show 1 more comment
-2
I ask this question for small model of my main table.
I have a table Product and I want a result table like this from a SQL query:
Color | existing Color count | existing sizes from this color
----------+------------------------+--------------------------------
red | 20 | 3
black | 12 | 4
Product table has [Id, Name, Color, Size, Price] columns.
I wrote this SQL statement:
SELECT
Color,
COUNT(Color) AS "numbers",
COUNT(Size) AS "sizes"
FROM
[Production].[Product]
GROUP BY
Color, Size;
edited Nov 24 '18 at 7:18
marc_s
578k12911161261
asked Nov 23 '18 at 21:23
miladhpmiladhp
2618
1
Pure code-writing requests are off-topic on Stack Overflow — we expect questions here to relate to specific programming problems — but we will happily help you write it yourself! Tell us what you've tried, and where you are stuck. See How to Ask for more information. This will also help us answer your question better.
– rsjaffe
Nov 23 '18 at 21:29
@rsjaffe I added my tried code.
– miladhp
Nov 23 '18 at 21:33
1
What's the result of your query? Are you receiving an error or just an undesired result?
– versvs
Nov 23 '18 at 21:33
@versvs I receive the undesired result.
– miladhp
Nov 23 '18 at 21:34
Provide the input data sample ?
– Himanshu Ahuja
Nov 23 '18 at 21:37
|
show 1 more comment
-2
-2
-2
1
I ask this question for small model of my main table.
I have a table Product and I want a result table like this from a SQL query:
Color | existing Color count | existing sizes from this color
----------+------------------------+--------------------------------
red | 20 | 3
black | 12 | 4
Product table has [Id, Name, Color, Size, Price] columns.
I wrote this SQL statement:
SELECT
Color,
COUNT(Color) AS "numbers",
COUNT(Size) AS "sizes"
FROM
[Production].[Product]
GROUP BY
Color, Size;
edited Nov 24 '18 at 7:18
marc_s
578k12911161261
asked Nov 23 '18 at 21:23
miladhpmiladhp
2618
I ask this question for small model of my main table.
I have a table Product and I want a result table like this from a SQL query:
Color | existing Color count | existing sizes from this color
----------+------------------------+--------------------------------
red | 20 | 3
black | 12 | 4
Product table has [Id, Name, Color, Size, Price] columns.
I wrote this SQL statement:
SELECT
Color,
COUNT(Color) AS "numbers",
COUNT(Size) AS "sizes"
FROM
[Production].[Product]
GROUP BY
Color, Size;
edited Nov 24 '18 at 7:18
marc_s
578k12911161261
asked Nov 23 '18 at 21:23
miladhpmiladhp
2618
edited Nov 24 '18 at 7:18
marc_s
578k12911161261
asked Nov 23 '18 at 21:23
miladhpmiladhp
2618
edited Nov 24 '18 at 7:18
marc_s
578k12911161261
edited Nov 24 '18 at 7:18
marc_s
578k12911161261
edited Nov 24 '18 at 7:18
marc_s
578k12911161261
578k12911161261
asked Nov 23 '18 at 21:23
miladhpmiladhp
2618
asked Nov 23 '18 at 21:23
miladhpmiladhp
2618
asked Nov 23 '18 at 21:23
miladhpmiladhp
2618
2618
1
Pure code-writing requests are off-topic on Stack Overflow — we expect questions here to relate to specific programming problems — but we will happily help you write it yourself! Tell us what you've tried, and where you are stuck. See How to Ask for more information. This will also help us answer your question better.
– rsjaffe
Nov 23 '18 at 21:29
@rsjaffe I added my tried code.
– miladhp
Nov 23 '18 at 21:33
1
What's the result of your query? Are you receiving an error or just an undesired result?
– versvs
Nov 23 '18 at 21:33
@versvs I receive the undesired result.
– miladhp
Nov 23 '18 at 21:34
Provide the input data sample ?
– Himanshu Ahuja
Nov 23 '18 at 21:37
|
show 1 more comment
1
Pure code-writing requests are off-topic on Stack Overflow — we expect questions here to relate to specific programming problems — but we will happily help you write it yourself! Tell us what you've tried, and where you are stuck. See How to Ask for more information. This will also help us answer your question better.
– rsjaffe
Nov 23 '18 at 21:29
@rsjaffe I added my tried code.
– miladhp
Nov 23 '18 at 21:33
1
What's the result of your query? Are you receiving an error or just an undesired result?
– versvs
Nov 23 '18 at 21:33
@versvs I receive the undesired result.
– miladhp
Nov 23 '18 at 21:34
Provide the input data sample ?
– Himanshu Ahuja
Nov 23 '18 at 21:37
1
1
Pure code-writing requests are off-topic on Stack Overflow — we expect questions here to relate to specific programming problems — but we will happily help you write it yourself! Tell us what you've tried, and where you are stuck. See How to Ask for more information. This will also help us answer your question better.
– rsjaffe
Nov 23 '18 at 21:29
Pure code-writing requests are off-topic on Stack Overflow — we expect questions here to relate to specific programming problems — but we will happily help you write it yourself! Tell us what you've tried, and where you are stuck. See How to Ask for more information. This will also help us answer your question better.
– rsjaffe
Nov 23 '18 at 21:29
@rsjaffe I added my tried code.
– miladhp
Nov 23 '18 at 21:33
@rsjaffe I added my tried code.
– miladhp
Nov 23 '18 at 21:33
1
1
What's the result of your query? Are you receiving an error or just an undesired result?
– versvs
Nov 23 '18 at 21:33
What's the result of your query? Are you receiving an error or just an undesired result?
– versvs
Nov 23 '18 at 21:33
@versvs I receive the undesired result.
– miladhp
Nov 23 '18 at 21:34
@versvs I receive the undesired result.
– miladhp
Nov 23 '18 at 21:34
Provide the input data sample ?
– Himanshu Ahuja
Nov 23 '18 at 21:37
Provide the input data sample ?
– Himanshu Ahuja
Nov 23 '18 at 21:37
|
show 1 more comment
1 Answer
1
active
oldest
votes
2
Select color,count(color),count(distinct size) from table
group by color;
Is this what you want ?
answered Nov 23 '18 at 21:33
Himanshu AhujaHimanshu Ahuja
7442217
It is worked but didn't countNULLas a size type. I want to count that rows hasn't any size value. is it possible?
– miladhp
Nov 23 '18 at 21:52
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%2f53453069%2fsql-query-for-product-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
2
Select color,count(color),count(distinct size) from table
group by color;
Is this what you want ?
answered Nov 23 '18 at 21:33
Himanshu AhujaHimanshu Ahuja
7442217
It is worked but didn't countNULLas a size type. I want to count that rows hasn't any size value. is it possible?
– miladhp
Nov 23 '18 at 21:52
add a comment |
2
Select color,count(color),count(distinct size) from table
group by color;
Is this what you want ?
answered Nov 23 '18 at 21:33
Himanshu AhujaHimanshu Ahuja
7442217
It is worked but didn't countNULLas a size type. I want to count that rows hasn't any size value. is it possible?
– miladhp
Nov 23 '18 at 21:52
add a comment |
2
2
2
Select color,count(color),count(distinct size) from table
group by color;
Is this what you want ?
answered Nov 23 '18 at 21:33
Himanshu AhujaHimanshu Ahuja
7442217
Select color,count(color),count(distinct size) from table
group by color;
Is this what you want ?
answered Nov 23 '18 at 21:33
Himanshu AhujaHimanshu Ahuja
7442217
edited Nov 23 '18 at 21:39
answered Nov 23 '18 at 21:33
Himanshu AhujaHimanshu Ahuja
7442217
answered Nov 23 '18 at 21:33
Himanshu AhujaHimanshu Ahuja
7442217
answered Nov 23 '18 at 21:33
Himanshu AhujaHimanshu Ahuja
7442217
7442217
It is worked but didn't countNULLas a size type. I want to count that rows hasn't any size value. is it possible?
– miladhp
Nov 23 '18 at 21:52
add a comment |
It is worked but didn't countNULLas a size type. I want to count that rows hasn't any size value. is it possible?
– miladhp
Nov 23 '18 at 21:52
It is worked but didn't count
NULL as a size type. I want to count that rows hasn't any size value. is it possible?– miladhp
Nov 23 '18 at 21:52
It is worked but didn't count
NULL as a size type. I want to count that rows hasn't any size value. is it possible?– miladhp
Nov 23 '18 at 21:52
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%2f53453069%2fsql-query-for-product-table%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
1
Pure code-writing requests are off-topic on Stack Overflow — we expect questions here to relate to specific programming problems — but we will happily help you write it yourself! Tell us what you've tried, and where you are stuck. See How to Ask for more information. This will also help us answer your question better.
– rsjaffe
Nov 23 '18 at 21:29
@rsjaffe I added my tried code.
– miladhp
Nov 23 '18 at 21:33
1
What's the result of your query? Are you receiving an error or just an undesired result?
– versvs
Nov 23 '18 at 21:33
@versvs I receive the undesired result.
– miladhp
Nov 23 '18 at 21:34
Provide the input data sample ?
– Himanshu Ahuja
Nov 23 '18 at 21:37