Re: "select" simple question?

From: Nikita Kouzin <nikita_at_finmarket.ru>
Date: Thu, 25 Mar 1999 11:27:19 +0300
Message-ID: <7dcrvc$deg$1@swan.glas.apc.org>

Hi
At some WEB server i taken a useful info for myself: "select DISTINCT field from table" is like "select field from table order by field ASC"
where field is numeric field
It's choose give me to use that Oracle'possible to view and then got sort and rownum
in my view
It's solusion to retrieve n rows from table by sort

Kind Regard
Nikita Kouzin
nikita_at_finmarket.ru

Jack Zhu wrote in message <7d990t$2qr$1_at_news.monmouth.com>...
>How can I use "select" to retrive first 10 rows of a table?
>
>Thanks in advance!
>
>Pls email me!
>
>jackzhu_at_monmouth.com
>
>
Received on Thu Mar 25 1999 - 02:27:19 CST