All Questions
19 questions
2
votes
1
answer
64
views
Query for single return meeting multiple criteria and values
I'm trying to figure out a way to count an ID once when multiple criteria are met in one column while displaying a total of the same criteria in another column. The criteria for the first column can ...
- 75
-2
votes
1
answer
24
views
Extracting data from two tables
I have( for example) a table called A and a table called B.
Table A contains tons of user data( age, country bla bla) and is connected to B by forein_key=id( B only has ID/NAME.
I want to find out how ...
- 1
-2
votes
1
answer
600
views
Having trouble with where subquery count
Assume all of the table and field names are correct. I've tried this a few different ways but this is the only that makes sense needing the join in both. This is the question:
SQL query to get the ...
0
votes
0
answers
130
views
MySQL - Counting multiple parameters from the same subquery
I have a very large MySQL (~10M rows) database, currently using the InnoDB engine, which stores log events. I am working on a front-end that allows searching through this log database, and one of the ...
- 3
1
vote
2
answers
616
views
How to get sum of 3 sub count queries and group them using an attribute
I have 3 queries as follows:
For the date 2019-12-02, I am calculating 3 type of values. The total value for 2019-12-02 must be the sum of these 3 queries.
Q1
SELECT count(*)
FROM ...
1
vote
1
answer
4k
views
Sub Query with group by returns more than 1 row Issue
I am facing the issue of subquery returns more than 1 row cause I am using group by in the subquery and outer query both to get the desired result.
This is my query
SELECT Count(*) ...
0
votes
1
answer
2k
views
Optimize slow COUNT in MySQL subquery
I have the following query that takes minutes to complete:
SELECT DISTINCT Designation, Model, (
SELECT COUNT( Equipment.EquipmentID )
FROM Equipment
INNER JOIN EquipmentDesignation_Vw ...
- 1
0
votes
1
answer
1k
views
MySQL Subquery count
I need to find how many resources are available in depot when transit arrives. I need to have transit name and resource count on result. I'm using MySQL. I wrote this but it gives me error when adding ...
- 101
2
votes
1
answer
3k
views
Calculate quantity of tickets based on how many reserved using sub queries
I'm designing a database that will hold ticketing information. The 3 tables I use to track ticketing are
tbl_ticket_type to the types of events an event can have
tbl_ticket_count to keep track of ...
- 325
0
votes
3
answers
399
views
Rewriting query with subquery to improve performance [closed]
My query looks like that
SELECT topics.name, topics.topic_id, topics.creator,
( SELECT COUNT(*) FROM answers
WHERE answers.topic_id = topics.topic_id)
AS replies FROM topics
ORDER BY topics....
- 13
2
votes
2
answers
12k
views
Complex joins in multiple subqueries
Sorry to keep bugging you guys, but SQL is still new to me. I have these tables:
Store_location, Product, Sizes, Sells, Available_in, Offers, and Currency.
The goal is to be able to run one query with ...
- 75
0
votes
1
answer
54
views
Mysql query to get count result and group by
I've got three tables with different records for users,
User
username | realname | date
evn-az-3ju john 11/2012 03:09:40 p.m.
jwyvm_rdyt steve 12/2012 ...
- 101
1
vote
1
answer
37
views
Selecting entries with the same count as in another table
I'm using a SELECT statement to select multiple IDs and than use
GROUP BY ID
HAVING COUNT(*) = someNumber
to only have the IDs with a certain count.
What I however actually want to do is to select ...
- 45
2
votes
2
answers
36k
views
Multiple COUNT fields, GROUP BY
I'm trying to group two columns in my MySQL database and show counts for them respectively (as separate columns). Is there a way of doing this or do I have to join two sub-queries?
I'm aware of WITH ...
1
vote
1
answer
3k
views
Postgres Nested WHEN Aggregate Function
In PostgreSQL (version 9.4) I am trying to construct a query to determine in various tranches how many times various numbers appear in the data set between ranges. When I query group-ing by "...
- 115
0
votes
1
answer
264
views
Count(*) as rolecount, filter by rolecount = 1
How can i filter out the rows who only got rolecount = 1?
WHERE rolecount = 1 gives an error. Can't really figure out how to do it.
SELECT
u.uid AS uid,
u.name AS name,
u.picture AS picture,
n....
- 103
0
votes
1
answer
68
views
How to optimise very simple query with subquery that only needs to execute once
SELECT products_id, products_model, products_iban_no, products_allocation_number FROM products WHERE products_model IN (SELECT products_model FROM products GROUP BY products_model HAVING COUNT(...
1
vote
1
answer
101
views
Counting number of visitors who did NOT log in
I'm trying to calculate the number of visitors to the homepage of my site who did NOT then log in to the member's section of the site, while also filtering bots and admin users. Bots and admins are ...
- 113
2
votes
1
answer
3k
views
How to UPDATE a column by COUNT of FK from another table?
How to extend this query for the entire table, to update all ids?
UPDATE table1 SET number=(
SELECT COUNT(*) FROM table2 where id=1
) WHERE id=1
id is the PRIMARY KEY in table1 and FK in table2.
...
- 4,531