Linked Questions
12 questions linked to/from GROUP BY without aggregate function
511
votes
18
answers
750k
views
Error related to only_full_group_by when executing a query in MySql
I have upgraded my system and have installed MySql 5.7.9 with php for a web application I am working on. I have a query that is dynamically created, and when run in older versions of MySQL it works ...
- 5,385
2
votes
1
answer
2k
views
JPA query with GROUP BY in Spring Data on Oracle database
I'm using Oracle as database and Spring Data on a project with jBoss AS.
A simple query with a GROUP BY doesn't work.
This is the Repository code:
public interface UseCaseRepository extends ...
- 143
0
votes
1
answer
1k
views
GROUP BY in SQL using netbeans
I'm building a web application that has a search engine. I'm using NetBeans ( Java ) and SQL databases.
I'm trying to (group by) the results of a search engine. So I don't get duplicate results and ...
3
votes
2
answers
479
views
Loop variable grouping by date
I have some sporting results that i'd like to loop through and group under dates in a table. For example;
|Sat, 20|
|Game 1 Results|
|Game 2 Results|
|Sun, 21|
|Game 3 Results|
|Sat, 27|
|Game 4 ...
- 1,096
-2
votes
1
answer
646
views
How can we group multiple record by foreign key [closed]
Suppose I have two table one is A and second is B. A has primary key Aid and B has foreign key B_foreignid which contain Aid i.e table A primary key and table B contain multiple Aid as foreign key.So ...
0
votes
1
answer
503
views
SQL - I am trying to isolate or group each transaction by each cardholder and my code is below
The code runs ok when i don't have the last line (GROUP BY ch.name). When I include the line I receive an error listed below - I am trying to get a query where I can identify and group many things ...
- 11
0
votes
1
answer
90
views
1
vote
2
answers
121
views
Error GROUP BY Dates MysQL
I am trying to group by dates 2 different tables. However, something is going wrong as I am not able to group by dates.
I have 2 tables First "Budget" and Second "Sales Performance By Region"
The ...
-1
votes
1
answer
56
views
How To Find Duplicate Of Single Word (Not Value) In A Column
I want to find duplicate of single word in my ItemDescription column. Please Look The Picture: https://i.sstatic.net/mBX7F.jpg .Not the duplicate value but the duplicate of single word with in the ...
0
votes
3
answers
53
views
Groups and Aggregate functions questions
SELECT HCIS,ServiceDate,PrimeInsMnemonic,TIN,Amount,SUM(Amount) AS Total
FROM dbo.PbrChargeTransactions
WHERE HCIS = 'ASL'
AND ServiceDate Between'01/01/16' and '12/31/16'
AND PrimeInsMnemonic = 'MED'
...
- 221
0
votes
0
answers
49
views
MYSQL wrong sum in join query
I have a query in MySQL designed with multi JOINs.
But the sum total value is different if I use a Group or just one total value.
If I run the query like below I get e.b. 3 lines with the correct ...
- 13
0
votes
0
answers
35
views
Can't get the values when compare two columns in sql
I need help with this query
select ca_city from AM_PROVISIONAL where ca_province='پنجاب' group by ca_city
when I run it, it shows the blank field but the database exists.
- 1,237