Re: Select Distinct (was top N or rewriting MAX)

In article <32E3D378.B2F_at_rci.rogers.com>, AWILSON (awilson_at_rci.rogers.com) says...
>
>or something along those lines, maybe using the rowid.
>
>Just a suggestion.

I believe the only way to retrieve a top N with SQL is to create an index on the column you're interested in, and select with a hint 'index_desc' on that index and a 'where rownum <= 10'.

-- 
Kind reGards
     \ /   |
      X    |
     / \   s
     Gerard