Home » RDBMS Server » Server Administration » Re: Free Blocks in a single sql query, Suresh
Re: Free Blocks in a single sql query, Suresh [message #370959] Tue, 14 March 2000 12:42
Hari Kurup
Messages: 3
Registered: March 2000
Junior Member
Hi Suresh,

Thanx for the query. But it doen't work for certain cases. Consider , the following scenario:
In table T, and column B i have the following data
1
2
3
4
5
6
9
10
11
12
13
The desired output will be:
Min_Block_no max_block_no No_of_blocks
1 6 6
9 13 5

but, the output of your query is
1 9 9
10 13 3
which is wrong.
Can u please, rectify your logic and post it again.

Regards,
Hari
Previous Topic: Fancy SQL*PLUS
Next Topic: Using select statement find the rank...
Goto Forum:
  


Current Time: Sat Oct 24 04:36:22 CDT 2020