r937
SQL Consultant
Devshed Supreme Being (6500+ posts)
- Join Date
- February 25th, 2003
- Last Activity
- Today 04:08 PM
Recent Visitors
- EmDev,
- Greum,
- Guelphdad,
- minhland2345,
- mumb991,
- ngocnhu97dn,
- oakleaf,
- phanxuan5,
- thithaodn47,
- Will-O-The-Wisp
-
Older Activity
-
yes, using SUM and GROUP BY in the same query is fine i am surprised you had to ask, because that is basic sql... i mean, really basic i have a...Today, 01:32 PM2 replies | 47 view(s)
-
r937 replied to a thread How can I update this query so not only I get unique ip, I also get unique email in MySQL Helpso give it one :)Yesterday, 10:57 AM18 replies | 341 view(s)
-
r937 replied to a thread How can I update this query so not only I get unique ip, I also get unique email in MySQL Helpbecause nothing suggested that you wanted only the emails!!! using SELECT * and GROUP BY ip suggested that you wanted all the other columns as...October 17th, 2017, 06:16 AM18 replies | 341 view(s)
-
r937 replied to a thread How can I update this query so not only I get unique ip, I also get unique email in MySQL Helpwell, that's just the thing... if you do it when it's correct to do it, then it isn't a gotcha, because all values of non-aggregated columns are...October 16th, 2017, 10:32 AM18 replies | 341 view(s)
-
r937 replied to a thread How can I update this query so not only I get unique ip, I also get unique email in MySQL Helpi agree, it seems wrong... there's way too much else going on in the grouping for example, suppose there are multiple emails for a given IP......October 16th, 2017, 09:37 AM18 replies | 341 view(s)
-
r937 replied to a thread How can I update this query so not only I get unique ip, I also get unique email in MySQL Helpi'm sorry, i don't speak php, perhaps someone elseOctober 16th, 2017, 07:21 AM18 replies | 341 view(s)
-
r937 replied to a thread How can I update this query so not only I get unique ip, I also get unique email in MySQL Helpbut SELECT * with GROUP BY does make sense... in MySQL actually the rationale for it is quite reasonable, the only problem is, so few actual...October 16th, 2017, 04:33 AM18 replies | 341 view(s)
-
no, a row for each one in an Ailments tableOctober 8th, 2017, 04:38 AM3 replies | 262 view(s)
-
also, why are you joining Players pl to Players y? also, the IS NOT NULL check here is redundant -- WHERE DateRedeemed is not null AND...October 6th, 2017, 12:56 PM4 replies | 310 view(s)
-
the first thing to do when analyzing any GROUP BY query that seems to be returning duplicates, is to remove the GROUP BY, make sure the PK from every...October 6th, 2017, 12:51 PM4 replies | 310 view(s)
-
SELECT articles.id , trans1.value AS title , trans2.value AS description FROM articles INNER JOIN translations AS trans1 ON...October 2nd, 2017, 11:46 AM2 replies | 216 view(s)
-
look at your data i think your query is fine no results means some join fields don't contain what you think is thereOctober 2nd, 2017, 07:38 AM5 replies | 259 view(s)
-
so what was wrong with your original query again?October 2nd, 2017, 03:53 AM5 replies | 259 view(s)
-
" should " what does this actually return? SELECT COUNT(*) FROM tblEmployee_Horse WHERE Employee_ID = 18September 29th, 2017, 04:25 PM5 replies | 259 view(s)
-
your human analogy doesn't work... SQL is not row-at-a-time, it is table-at-a-time remember, there is no "first"September 27th, 2017, 03:21 AM5 replies | 260 view(s)
-
no... it will return unique values... there is no "first" would who? um, recognized? processed? dude, what happened when you tested it? ™September 26th, 2017, 05:55 PM5 replies | 260 view(s)
-
also SELECT DISTINCT YEAR(`date`) FROM `invoice` it would be interesting to compare the EXPLAINs for these two approachesSeptember 26th, 2017, 11:52 AM5 replies | 260 view(s)
