Hi Neil,
On 11/22/2012 7:14 PM, h...@tbbs.net wrote:
2012/11/22 14:30 +, Neil Tompkins
I'm struggling with what I think is a basic select but can't think how to
do it : My data is
id,type
1000,5
1001,5
1002,2
1001,2
1003,2
1005,2
1006,1
From this I what to get a distinct list of id
Yeah, it's easy enough to do in python, but my client wanted a SQL query.
Thanks
On Tue, Dec 18, 2012 at 5:48 PM, Rick James wrote:
> GROUP BY .. WITH ROLLUP
> could get you something like that.
>
> Otherwise, I would advise that you use your application language (PHP, Java,
> etc) to do "pres
GROUP BY .. WITH ROLLUP
could get you something like that.
Otherwise, I would advise that you use your application language (PHP, Java,
etc) to do "presentation" type stuff.
Yes, it could be done is SQL, but my brain might explode if I try to conjure up
such.
> -Original Message-
> Fro
On 12/18/2012 3:52 AM, Haidar Pesebe wrote:
Hi all--
There are 3 tables which each like this:
NOTE: The linkage between table A and table B is ID and IDPUBLISHER, while Table
B to C is the ISBN. Sometimes there are some titles that are not sold
in a given month.
TABLE A (Publisher)
On 2012-12-18 2:52 AM, Haidar Pesebe wrote:
Hi all--
There are 3 tables which each like this:
NOTE: The linkage between table A and table B is ID and IDPUBLISHER, while Table
B to C is the ISBN. Sometimes there are some titles that are not sold
in a given month.
TABLE A (Publisher)
Hi Bheemsen,
looks like a few different things going on there; if you have a MySQL support
contract/subscription then it would be worth raising SRs - it doesn't need to
be a bug, it's fine tyo ask questions too. A couple of things that spring to
mind in-line
> I am frequently seeing the f