Home » SQL & PL/SQL » SQL & PL/SQL » windowing function
windowing function [message #20832] Mon, 24 June 2002 08:56 Go to next message
vipin
Messages: 40
Registered: May 2002
Member
Hi,

Please help me on the usage of windowing function.

I would like to get the maximum (accountvalue) and its associated acc_no in the table using this. I am writing the equivalent solution in pl/sql.

select
acc_no, accountamount
from
tra_account
where
accountamount = (select
max(accountamount)
from tra_account ) ;

Report message to a moderator

Re: windowing function [message #20842 is a reply to message #20832] Tue, 25 June 2002 07:38 Go to previous message
dug
Messages: 7
Registered: March 2002
Junior Member
use a rank function

Report message to a moderator

Previous Topic: DBMS_UTILITY.GET_LINE function's problem
Next Topic: URGENT !!! drop a user ???
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 16:26:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.