OraFAQ Forum: Forms » Item with last transactional date

Home » Developer & Programmer » Forms » Item with last transactional date

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Item with last transactional date [message #613778]

Mon, 12 May 2014 04:48

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi all,

SELECT illitm, 
       ildoc, 
       ildct, 
       iltrdj 
FROM   crpdta.f4111 
WHERE  iltrdj IN (SELECT Max(iltrdj) 
                  FROM   crpdta.f4111);

The above query is returning the latest transaction date with Item details.
But expected output is: Every Item with last transactional date.

Hope I am clear on the above requirement please.

Thanks in advance.

Report message to a moderator

Re: Item with last transactional date [message #613779 is a reply to message #613778]

Mon, 12 May 2014 04:53

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If I understood the question, inline view lacks in WHERE clause, such as

SELECT f.illitm, 
       f.ildoc, 
       f.ildct, 
       f.iltrdj 
FROM   crpdta.f4111 f
WHERE  f.iltrdj IN (SELECT Max(iltrdj) 
                    FROM   crpdta.f4111 f1
                    WHERE  f1.illitm = f.illitm
                   );

Report message to a moderator

Re: Item with last transactional date [message #613782 is a reply to message #613779]

Mon, 12 May 2014 05:15

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Thanks Littlefoot ... Smile

Report message to a moderator

Re: Item with last transactional date [message #613788 is a reply to message #613779]

Mon, 12 May 2014 05:29

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi Littlefoot ,The above modified which is keep on running and never throwing any output.

Report message to a moderator

Re: Item with last transactional date [message #613790 is a reply to message #613788]

Mon, 12 May 2014 05:41

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi Littlefoot Its keeps on running like indefinite loop... Smile

Once again Thanks

Report message to a moderator

Re: Item with last transactional date [message #613792 is a reply to message #613790]

Mon, 12 May 2014 06:34

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Copy your last query over here. Do not type it, copy/paste it.

Report message to a moderator

Re: Item with last transactional date [message #613795 is a reply to message #613792]

Mon, 12 May 2014 06:54

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Sorry for the lately inform to you

SELECT illitm,
ildoc,
ildct,
iltrdj
FROM crpdta.f4111
WHERE iltrdj IN (SELECT Max(iltrdj)
FROM crpdta.f4111);

[Updated on: Mon, 12 May 2014 06:58]

Report message to a moderator

Re: Item with last transactional date [message #613798 is a reply to message #613795]

Mon, 12 May 2014 07:02

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know what to say ... actually, I do, but I'd rather not.

Report message to a moderator

Re: Item with last transactional date [message #613804 is a reply to message #613798]

Mon, 12 May 2014 07:54

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

Does that look anything like what LF suggested?
Or does it look like what you posted in the first place?

Report message to a moderator

Previous Topic:	GIS for Oracle
Next Topic:	which query to use in push button trigger to auto execute when i pressed button

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 17 23:20:48 CDT 2025