Retrieve data in group based on the Value of other column

Posted by Seema on Stack Overflow See other posts from Stack Overflow or by Seema
Published on 2009-09-18T06:27:40Z Indexed on 2010/06/15 3:02 UTC
Read the original article Hit count: 237

Filed under:
|

I have one table with the following Column.

BoxNumber          Status
580                 4 
581                 4
582                 4
583                 4
584                 2
585                 2
586                 4
587                 4
588                 4
589                 4
590                 2
591                 2

I need one select Query to get the following output .

StartingBoxNumber EndingBoxNumber    Status
580                     583           4
584                     585           2
586                     589           4
590                     591           2

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about oracle10g