Hi Abhishek,
In a table i have 100s of rows with six categories like A,B,C,D,E,F
which is
marked with a column like
Table
ID Category
1 A
2 A
3 B
4 B
5 B
6 C
7 C
and so on 100 ids for each of six categories , i want to delete all
but 10
ids of each category, i wanted to know how to d
eName.ID=Smry.deleteID
- Original Message -
From: "abhishek jain" <[EMAIL PROTECTED]>
To:
Sent: Sunday, April 08, 2007 7:26 AM
Subject: Query needed for this sol.
Hi all,
I need a query for the fol. sol.
In a table i have 100s of rows with six categories like A,B,C,D,
Hi all,
I need a query for the fol. sol.
In a table i have 100s of rows with six categories like A,B,C,D,E,F which is
marked with a column like
Table
ID Category
1 A
2 A
3 B
4 B
5 B
6 C
7 C
and so on 100 ids for each of six categories , i want to delete all but 10
ids of each category, i
VenuGopal Papasani wrote:
Dear all,
I have a table with the following structure.
ield Type CollationNullKey Default
Extra Privileges Comment
--- -- -- ---
-
Dear all,
I have a table with the following structure.
ield Type CollationNullKey Default
Extra Privileges Comment
--- -- -- ---
--
VenuGopal Papasani wrote:
> Once again i send the table data:
>
> Code Period Value
> c12004 22
> c12005 10
> c22005 15
> c32005 20
> c42005 15
> c52005 5
> c62005 30
>
Not until we know the logic behind the "code" and how the calculations
should be done.
-Original Message-
From: VenuGopal Papasani [mailto:[EMAIL PROTECTED]
Sent: Monday, August 14, 2006 1:03 PM
To: Peter Lauri; mysql@lists.mysql.com
Subject: Re: query needed
if it is stat
de, 0))) -
SUM(IF(code='c4',
code, IF(code='c5', code, 0))) FROM datavalue;
-Original Message-
From: VenuGopal Papasani [mailto:[EMAIL PROTECTED]
Sent: Monday, August 14, 2006 11:26 AM
To: mysql@lists.mysql.com
Subject: query needed
Hi,
i got a table datavalue as
SELECT SUM(IF(code='c1', code, IF(code='c2', code, 0))) - SUM(IF(code='c4',
code, IF(code='c5', code, 0))) FROM datavalue;
-Original Message-
From: VenuGopal Papasani [mailto:[EMAIL PROTECTED]
Sent: Monday, August 14, 2006 11:26 AM
To: mysql@lists.
Once again i send the table data:
Code Period Value
c1 2004 22
c1 2005 10
c2 2005 15
c3 2005 20
c4 2005 15
c5 2005 5
c6 2005 30
c7 2005
VenuGopal Papasani wrote:
Hi,
i got a table datavalue as follows
code period value
c1 20051
c2 20052
c32006 3
Hi,
i got a table datavalue as follows
code period value
c1 20051
c2 20052
c32006 3
c4
* Reto Baumann
> I'm working on a book database with some special requirements.
> Each book is associated with some keywords and put into a
> category. Category 0 is special, as this is "Unsorted", i.e. not
> associated with a category (which most books are at the moment).
>
> For thei query, let's
Hi all
I'm working on a book database with some special requirements. Each book is associated
with some keywords and put into a category. Category 0 is special, as this is
"Unsorted", i.e. not associated with a category (which most books are at the moment).
For thei query, let's simplify the st
14 matches
Mail list logo
