How to send two query into one? Is there any other alternative?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
0
So I have this query that gets me the number of failed parts in the order. for example 94 failed. However, I want to see the total amount of parts in that order. For example, 94 failed and 200 total. How can I achieve that in one query? If it's not possible how can I combine two queries in one result table?
SELECT status, COUNT(order)
FROM result
WHERE status='failed' and order = '4373'
GROUP BY status
mysql
edited 7 mins ago
Mr.Brownstone
9,85232343
asked 1 hour ago
KashanKashan
1
New contributor
Kashan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
|
show 2 more comments
0
So I have this query that gets me the number of failed parts in the order. for example 94 failed. However, I want to see the total amount of parts in that order. For example, 94 failed and 200 total. How can I achieve that in one query? If it's not possible how can I combine two queries in one result table?
SELECT status, COUNT(order)
FROM result
WHERE status='failed' and order = '4373'
GROUP BY status
mysql
edited 7 mins ago
Mr.Brownstone
9,85232343
asked 1 hour ago
KashanKashan
1
New contributor
Kashan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Can you post the CREATE TABLE script please?
– George.Palacios
30 mins ago
I am not creating any tables. Just want to see the response from the select statment.
– Kashan
29 mins ago
I mean the CREATE TABLE script for the result table
– George.Palacios
28 mins ago
We'll also need some test data to work with
– George.Palacios
27 mins ago
I am not sure that I got your request right. I am just sending this query to the DB using DBbeaver and I see the reasult of the query in the bottom window. I am not creating tables thus I don't have the script for creating them.
– Kashan
18 mins ago
|
show 2 more comments
0
0
0
So I have this query that gets me the number of failed parts in the order. for example 94 failed. However, I want to see the total amount of parts in that order. For example, 94 failed and 200 total. How can I achieve that in one query? If it's not possible how can I combine two queries in one result table?
SELECT status, COUNT(order)
FROM result
WHERE status='failed' and order = '4373'
GROUP BY status
mysql
edited 7 mins ago
Mr.Brownstone
9,85232343
asked 1 hour ago
KashanKashan
1
New contributor
Kashan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
So I have this query that gets me the number of failed parts in the order. for example 94 failed. However, I want to see the total amount of parts in that order. For example, 94 failed and 200 total. How can I achieve that in one query? If it's not possible how can I combine two queries in one result table?
SELECT status, COUNT(order)
FROM result
WHERE status='failed' and order = '4373'
GROUP BY status
mysql
mysql
edited 7 mins ago
Mr.Brownstone
9,85232343
asked 1 hour ago
KashanKashan
1
New contributor
Kashan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 7 mins ago
Mr.Brownstone
9,85232343
asked 1 hour ago
KashanKashan
1
New contributor
Kashan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 7 mins ago
Mr.Brownstone
9,85232343
edited 7 mins ago
Mr.Brownstone
9,85232343
edited 7 mins ago
Mr.Brownstone
9,85232343
9,85232343
asked 1 hour ago
KashanKashan
1
New contributor
Kashan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 1 hour ago
KashanKashan
1
asked 1 hour ago
KashanKashan
1
1
New contributor
Kashan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Kashan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Kashan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Can you post the CREATE TABLE script please?
– George.Palacios
30 mins ago
I am not creating any tables. Just want to see the response from the select statment.
– Kashan
29 mins ago
I mean the CREATE TABLE script for the result table
– George.Palacios
28 mins ago
We'll also need some test data to work with
– George.Palacios
27 mins ago
I am not sure that I got your request right. I am just sending this query to the DB using DBbeaver and I see the reasult of the query in the bottom window. I am not creating tables thus I don't have the script for creating them.
– Kashan
18 mins ago
|
show 2 more comments
Can you post the CREATE TABLE script please?
– George.Palacios
30 mins ago
I am not creating any tables. Just want to see the response from the select statment.
– Kashan
29 mins ago
I mean the CREATE TABLE script for the result table
– George.Palacios
28 mins ago
We'll also need some test data to work with
– George.Palacios
27 mins ago
I am not sure that I got your request right. I am just sending this query to the DB using DBbeaver and I see the reasult of the query in the bottom window. I am not creating tables thus I don't have the script for creating them.
– Kashan
18 mins ago
Can you post the CREATE TABLE script please?
– George.Palacios
30 mins ago
Can you post the CREATE TABLE script please?
– George.Palacios
30 mins ago
I am not creating any tables. Just want to see the response from the select statment.
– Kashan
29 mins ago
I am not creating any tables. Just want to see the response from the select statment.
– Kashan
29 mins ago
I mean the CREATE TABLE script for the result table
– George.Palacios
28 mins ago
I mean the CREATE TABLE script for the result table
– George.Palacios
28 mins ago
We'll also need some test data to work with
– George.Palacios
27 mins ago
We'll also need some test data to work with
– George.Palacios
27 mins ago
I am not sure that I got your request right. I am just sending this query to the DB using DBbeaver and I see the reasult of the query in the bottom window. I am not creating tables thus I don't have the script for creating them.
– Kashan
18 mins ago
I am not sure that I got your request right. I am just sending this query to the DB using DBbeaver and I see the reasult of the query in the bottom window. I am not creating tables thus I don't have the script for creating them.
– Kashan
18 mins ago
|
show 2 more comments
1 Answer
1
active
oldest
votes
0
SELECT SUM(status='failed') AS failed_orders, COUNT(1) AS total_orders
FROM result
WHERE order = '4373'
-- GROUP BY status -- ??
answered 18 mins ago
AkinaAkina
4,8081311
When I try to send the query I get this response: Operand data type varchar is invalid for sum operator
– Kashan
8 mins ago
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
Kashan is a new contributor. Be nice, and check out our Code of Conduct.
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%2fdba.stackexchange.com%2fquestions%2f234294%2fhow-to-send-two-query-into-one-is-there-any-other-alternative%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
0
SELECT SUM(status='failed') AS failed_orders, COUNT(1) AS total_orders
FROM result
WHERE order = '4373'
-- GROUP BY status -- ??
answered 18 mins ago
AkinaAkina
4,8081311
When I try to send the query I get this response: Operand data type varchar is invalid for sum operator
– Kashan
8 mins ago
add a comment |
0
SELECT SUM(status='failed') AS failed_orders, COUNT(1) AS total_orders
FROM result
WHERE order = '4373'
-- GROUP BY status -- ??
answered 18 mins ago
AkinaAkina
4,8081311
When I try to send the query I get this response: Operand data type varchar is invalid for sum operator
– Kashan
8 mins ago
add a comment |
0
0
0
SELECT SUM(status='failed') AS failed_orders, COUNT(1) AS total_orders
FROM result
WHERE order = '4373'
-- GROUP BY status -- ??
answered 18 mins ago
AkinaAkina
4,8081311
SELECT SUM(status='failed') AS failed_orders, COUNT(1) AS total_orders
FROM result
WHERE order = '4373'
-- GROUP BY status -- ??
answered 18 mins ago
AkinaAkina
4,8081311
answered 18 mins ago
AkinaAkina
4,8081311
answered 18 mins ago
AkinaAkina
4,8081311
answered 18 mins ago
AkinaAkina
4,8081311
4,8081311
When I try to send the query I get this response: Operand data type varchar is invalid for sum operator
– Kashan
8 mins ago
add a comment |
When I try to send the query I get this response: Operand data type varchar is invalid for sum operator
– Kashan
8 mins ago
When I try to send the query I get this response: Operand data type varchar is invalid for sum operator
– Kashan
8 mins ago
When I try to send the query I get this response: Operand data type varchar is invalid for sum operator
– Kashan
8 mins ago
add a comment |
Kashan is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
Kashan is a new contributor. Be nice, and check out our Code of Conduct.
Kashan is a new contributor. Be nice, and check out our Code of Conduct.
Kashan is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f234294%2fhow-to-send-two-query-into-one-is-there-any-other-alternative%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
Can you post the CREATE TABLE script please?
– George.Palacios
30 mins ago
I am not creating any tables. Just want to see the response from the select statment.
– Kashan
29 mins ago
I mean the CREATE TABLE script for the result table
– George.Palacios
28 mins ago
We'll also need some test data to work with
– George.Palacios
27 mins ago
I am not sure that I got your request right. I am just sending this query to the DB using DBbeaver and I see the reasult of the query in the bottom window. I am not creating tables thus I don't have the script for creating them.
– Kashan
18 mins ago