Sorry for the off-topic, but I have been beating on this one for a while and
the only answer I can find is really, really ugly. So, hopefully somebody
knows more about queries that I do and can show me the error of my ways
I have a table that looks something like this
crID
select t.* from test t where t.actid in
(SELECT MAX(t2.actID) FROM test t2 where t2.crID = t.crID)
ought to work...
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.fusiontap.com
Jeff Chastain wrote:
I have a table that looks something like this
crIDactIDdescriptionowner
1 1Test 444
1 2Test Update124
2 1Test 578
Now, what I need is a listing of all distinct
I knew there was any easier way to do this.
Thanks
-- Jeff
From: S. Isaac Dealey [EMAIL PROTECTED]
Sent: Friday, May 20, 2005 9:16 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: OT: SQL Query Question
select t.* from test t where t.actid
this.
Thanks
-- Jeff
From: S. Isaac Dealey [EMAIL PROTECTED]
Sent: Friday, May 20, 2005 9:16 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: OT: SQL Query Question
select t.* from test t where t.actid in
(SELECT MAX(t2.actID) FROM test t2
5 matches
Mail list logo