How to select a random row from each sub table after "group by"?

From: Phper <hi.steven.tu_at_gmail.com>
Date: Wed, 3 Jun 2009 22:09:16 -0700 (PDT)
Message-ID: <bcf121c0-4a92-4446-9a30-70f7bc7f62eb_at_t10g2000vbg.googlegroups.com>

After "group by", the big table is grouped into many sub tables. I want to select a random row from each sub table. That's what I want. How can I realize/implement it? Received on Thu Jun 04 2009 - 00:09:16 CDT

This message: [ Message body ]
Next message: qualitat8_at_gmail.com: "Oracle configuration related weird behaviour?"
Previous message: Palooka: "Re: Refresh Materialized view manually"
Next in thread: steph: "Re: How to select a random row from each sub table after "group by"?"
Reply: steph: "Re: How to select a random row from each sub table after "group by"?"
Reply: yossarian: "Re: How to select a random row from each sub table after "group by"?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message