Home » SQL & PL/SQL » SQL & PL/SQL » number of records in each group
number of records in each group [message #7859] Sun, 13 July 2003 21:22 Go to next message
T. Kumar
Messages: 1
Registered: July 2003
Junior Member
Hi Friends

My table contans account number, name and adderss. In the account number contains branch number also. Now based on the branch code in account number I need to fetch 3 records from each branch.

Can you help on this.

Regards
T. Kumar

Report message to a moderator

Re: number of records in each group [message #7860 is a reply to message #7859] Mon, 14 July 2003 00:02 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Use SUBSTR/INSTR to get the branch code out of the account number. Use this result in a join.

If you want more details, give some examples + table layout.

MHE

Report message to a moderator

Previous Topic: index query
Next Topic: partition
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 00:01:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.