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
572k12811041252
asked Nov 23 '18 at 21:23
miladhpmiladhp
2418
|
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
572k12811041252
asked Nov 23 '18 at 21:23
miladhpmiladhp
2418
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
572k12811041252
asked Nov 23 '18 at 21:23
miladhpmiladhp
2418
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
572k12811041252
asked Nov 23 '18 at 21:23
miladhpmiladhp
2418
edited Nov 24 '18 at 7:18
marc_s
572k12811041252
asked Nov 23 '18 at 21:23
miladhpmiladhp
2418
edited Nov 24 '18 at 7:18
marc_s
572k12811041252
edited Nov 24 '18 at 7:18
marc_s
572k12811041252
edited Nov 24 '18 at 7:18
marc_s
572k12811041252
572k12811041252
asked Nov 23 '18 at 21:23
miladhpmiladhp
2418
asked Nov 23 '18 at 21:23
miladhpmiladhp
2418
asked Nov 23 '18 at 21:23
miladhpmiladhp
2418
2418
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
633216
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
633216
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
633216
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
633216
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
633216
edited Nov 23 '18 at 21:39
answered Nov 23 '18 at 21:33
Himanshu AhujaHimanshu Ahuja
633216
answered Nov 23 '18 at 21:33
Himanshu AhujaHimanshu Ahuja
633216
answered Nov 23 '18 at 21:33
Himanshu AhujaHimanshu Ahuja
633216
633216
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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