Date: Sat, 07 Apr 2001 15:01:20 GMT
Message-ID: <4ZFz6.1084$ix4.657070_at_news1.rdc1.sfba.home.com>
SQL> select two,one,four from test;
6 rows selected.
SQL> get junk1
TWO ONE FOUR
-------------------- ---------- ----------------------------------------
is this data
fun more dick and jane
two one four
two most yowsa
two bosco yowsa
two zabba yowsa
1 select a.two, a.one, a.four from test a
2* where rownum = (select max(rownum) from test b where a.two = b.two)
SQL> /
TWO ONE FOUR
-------------------- ---------- ----------------------------------------
is this data
I expected ....
is this data fun more dick and jane two zabba yowsa
This technique seems to get what I want if I use another column of the
table instead of rownum.
Why does it stop prematurely?
thanks
Mike
Received on Sat Apr 07 2001 - 17:01:20 CEST