Re: first row with sql?

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 29 Mar 2001 20:25:03 -0800
Message-ID: <3AC40A9F.F75EFCB3@exesolutions.com>

> With MSaccess there is a 'Group by' function FIRST which select only
> the first row of each group like SUM,AVG etc...
>
> how to do that with Oracle SQL?

Oracle supports the full SQL language syntax including the following clauses to a select statement:

SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY But be aware of one thing ... Access SQL is not real SQL. You need to read the manual or buy and read a book if you want to work with a real RDBMS. Daniel A. Morgan Received on Thu Mar 29 2001 - 22:25:03 CST