Re: SQL QUESTION: PLEASE HELP!!!!
From: Hank Robinson <cudau_at_csv.warwick.ac.uk>
Date: 22 Jul 1994 14:54:36 +0100
Message-ID: <30oj2s$bm3_at_crocus.csv.warwick.ac.uk>
Date: 22 Jul 1994 14:54:36 +0100
Message-ID: <30oj2s$bm3_at_crocus.csv.warwick.ac.uk>
z50816_at_mip.lasc.lockheed.com (Terry Greenlaw) writes:
> In article <30j1p3$hc_at_crocus.csv.warwick.ac.uk>, cudau_at_csv.warwick.ac.uk
> (Hank Robinson) writes:
>> This looks a bit messy, but this is my best shot...
> [info deleted so newsreader won't choke]
>> Select A.Ticket_Number "first of group" <<< needs comma here
>> B.Ticket_Number "last of group" (little nit)
>> From X A,
>> X B
Ooops...
> needs where a.ticket_status <= b.ticket_status and ...
Ahha, yes, sorry, you're right, but I presume you mean ticket_number, rather than ticket_status, ie.
needs Where A.Ticket_Number <= B.Ticket_Number And A.Ticket_Status Is Null And ...
> Cool solution ...
:-) thanks
> Terry Greenlaw
> z50816_at_mip.lasc.lockheed.com
Hank Robinson.
Oracle DBA,
University of Warwick.
Received on Fri Jul 22 1994 - 15:54:36 CEST