how to pull just a single member from v$logfile

Hi group,

Need help in writing a query.
I have 6 groups in a database and in each of these groups I have 2 members. I need to write a query where in it pulls only one member from each of the group

select a.group#,a.thread#,b.member from v$log a,v$logfile b where a.group#=b.group#;

    GROUP# THREAD# MEMBER
---------- ---------- --------------------

         1          1 /dev/rorarptlv00801
         1          1 /dev/rorarptlv00901
         2          1 /dev/rorarptlv00802
         2          1 /dev/rorarptlv00902
         3          1 /dev/rorarptlv00803
         3          1 /dev/rorarptlv00903
         4          1 /dev/rorarptlv00804
         4          1 /dev/rorarptlv00904
         5          1 /dev/rorarptlv00805
         5          1 /dev/rorarptlv00905
         6          1 /dev/rorarptlv00806
         6          1 /dev/rorarptlv00906

I know this is a wrong place to ask, but I think my dba community can help me out here.

Any help will be greatly appreciated.

Thanks in advance
Sam

--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 21 2008 - 12:57:35 CST