Home » SQL & PL/SQL » SQL & PL/SQL » Help !!! URGENT PLEASE.
Help !!! URGENT PLEASE. [message #395] Sat, 09 February 2002 09:13 Go to next message
jack
Messages: 123
Registered: September 2000
Senior Member
Hi All,

I have a current BANDWIDTH table contains as below

SVCTYPE MAXCELLRATE MINCELLRATE UNITSMAX UNITSMIN
------- ----------- ----------- -------- --------
1 3000 0 3 1
1 10000 0 2 1
1 3500 0 1 1
3 3000 3000 1 3
3 1200 12 2 2
3 5000 10000 3 1

In SVCTYPE column.

1 = CBR (Constant Bit Rate)
3 = ABR (Available Bit Rate)

In UNITSMAX/UNITSMIN columns.

1 = bps
2 = Kbps
3 = Mbps

I need to do the sum of MAXCELLRATE for CBR and the
sum of MINCELLRATE for ABR that will not exceed
total bandwidth 130 Mbps (130.000000 bps).

Thanks in Advance.

Jack
Re: Help !!! URGENT PLEASE. [message #407 is a reply to message #395] Mon, 11 February 2002 04:52 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
see these statements, it may give u some idea.i am not sure what is ur objective . sorry if i have messed u up.

--CBR
select sum(maxcellrate*power(1024,unitsmax-1)
from bandwidth
where svctype=1

--ABR
select sum(mincellrate*power(1024,unitsmin-1)
from bandwidth
where svctype=3
Re: Help !!! URGENT PLEASE. [message #412 is a reply to message #395] Mon, 11 February 2002 06:48 Go to previous message
jack
Messages: 123
Registered: September 2000
Senior Member
thanks, pratap.
Previous Topic: trigger
Next Topic: HOW TO WRITE A REQUEST IN ONE LINE WITH COMMENTS?
Goto Forum:
  


Current Time: Tue Aug 11 20:15:25 CDT 2020