On Jun 18, 1:29 pm, Michael Moore <michaeljmo...@gmail.com> wrote:
> another solution:
>
> DROP TABLE samp;
> CREATE TABLE samp AS
> SELECT '9-1' act, 300 beg, 350 nd FROM DUAL UNION ALL
> SELECT '9-2' act, 350 beg, 310 nd FROM DUAL UNION ALL
> SELECT '9-3' act, 310 beg, 301 nd FROM DUAL UNION ALL
> SELECT '9-4' act, 301 beg, 340 nd FROM DUAL UNION ALL
> SELECT '9-5' act, 340 beg, 330 nd FROM DUAL UNION ALL
> SELECT '8-1' act, 399 beg, 350 nd FROM DUAL UNION ALL
> SELECT '8-2' act, 350 beg, 610 nd FROM DUAL UNION ALL
> SELECT '8-3' act, 314 beg, 301 nd FROM DUAL UNION ALL
> SELECT '8-4' act, 301 beg, 111 nd FROM DUAL;
>
> SELECT DISTINCT SUBSTR( act, 1, 1 ),
> FIRST_VALUE( beg ) OVER( PARTITION BY SUBSTR( act, 1, 1 )
> ORDER BY act ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED
> FOLLOWING )
>
> bop,
> LAST_VALUE( nd ) OVER( PARTITION BY SUBSTR( act, 1, 1 )
> ORDER BY act ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED
> FOLLOWING )
>
> eop
> FROM samp;
Oh, sure, use analytics ... :D
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
