no
id grp cmod dmod
1 1 1 1
2 1 1 1
original query returns one row
your query should return 2 rows
I think he needs to give a specific example of what he wants (ie values, as
above) to get an answer that relates to his problem.
david jencks
On 2001.10.10 03:25:35 -0400 Edward Q.
would this do it?
select grp, cmod, dmod from table where
grp in (select distinct grp from table)
On Tue, 9 Oct 2001 19:17:43 -0400, David Jencks wrote:
>unfortunately your question makes no sense. If the GRP value does not
>determine the CMOD and DMOD values, which one of the rows with a g
Dave I think his grasp of relational theory is weak, so I doubt that answer
will mean anything to him. Let me have a go.
Your desire to use DISTINCT implies that there can be more than one row with
a given value of GRP in it.
Each one of these rows has its own copy of CMOD and DMOD. How do you ex
unfortunately your question makes no sense. If the GRP value does not
determine the CMOD and DMOD values, which one of the rows with a given GRP
value do you want? If there is an aggregation function that can sensibly
be applied to CMOD and DMOD, you can do a group by query select grp,
f(CMOD),
Sorry my internet access is down so I am going to try and ask this question
here instead of at a related site.
I need to do a query like this:
String sql="SELECT DISTINCT GRP,CMOD,DMOD FROM TABLE";
The problem is I only want distinct on the first column(GRP) but it returns
all distinct combinatio
e-1_0.jar
/Fredrik
-Ursprungligt meddelande-
Från: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]För Jason Wells
Skickat: den 24 maj 2001 02:46
Till: [EMAIL PROTECTED]
Ämne: [JBoss-user] SQL query tracing -- how?
Hello,
I'm running JBoss 2.1, and I need to turn on SQL tracing so
t;
Sent: Thursday, May 24, 2001 2:45 AM
Subject: [JBoss-user] SQL query tracing -- how?
> Hello,
>
> I'm running JBoss 2.1, and I need to turn on SQL tracing so that I can
debug
> a BMP entity bean I'm working on. I'm trying to get my server.log to give
me
> output
be in your connection pool (datasource); I don't know of
any that have this feature, though.
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jason Wells
Sent: Wednesday, May 23, 2001 8:46 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] SQL que
Hello,
I'm running JBoss 2.1, and I need to turn on SQL tracing so that I can debug
a BMP entity bean I'm working on. I'm trying to get my server.log to give me
output like this:
...
[JAWS] Exists SQL: SELECT COUNT(*) FROM UnitStatus WHERE id=?
[JAWS] findAllStatus SQL: SELECT id FROM UnitStatus
add true to your jaws.xml, at the 'top' level (within the
tag, but not in any other. Also, make sure that you're allowing
debug level logs to be output.
-danch
Chris Campbell wrote:
> Hi,
>
> We've recently moved from 2.0_Final to 2.2.1, and are very pleased with
> the improvements and add
Hi,
We've recently moved from 2.0_Final to 2.2.1, and are very pleased with the
improvements and added functionality. One thing we can't figure out,
however, is how to get SQL query strings to be logged to the console. With
2.0_Final we could see exactly what the container was trying to do (we
11 matches
Mail list logo
