Home » SQL & PL/SQL » SQL & PL/SQL » First Row of a Sub Table
First Row of a Sub Table [message #226381] Fri, 23 March 2007 08:02 Go to next message
Messages: 45
Registered: December 2006
Hey Everyone.

I am building a report, and have a strange request.

I have a table of accounts, and a table of remarks.

They are linked together by Account and LocationCode.

The remarks table holds comments for each account.

the Remarks table has 3 columns Account,Location,Remark.

There can be Many remarks for each account.

I am wanting to pull accounts that have a specific remark on the FIRST remark.

Thanks for all your help.
Re: First Row of a Sub Table [message #226390 is a reply to message #226381] Fri, 23 March 2007 08:44 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
Sorry, with those columns in your remark table, you are out of luck. How would YOU recognize your first remark?
Previous Topic: how to insert timestamp
Next Topic: New to Oracle
Goto Forum:

Current Time: Fri Aug 18 09:38:36 CDT 2017

Total time taken to generate the page: 0.17929 seconds