Re: using MAX function...

From: Stephan Born <stephan.born_at_beusen.de>
Date: Thu, 16 Mar 2000 09:39:01 +0100
Message-ID: <38D09DA4.FBC2DC0F@beusen.de>

Rookie schrieb:

> I have a table that has user_id, first_name, and last_name.
>
> How do I write a view that lets me see all three fields with the
> max(user_id)?

Use one of the following statements:

select

 p.user_id,
 p.last_name,
 p.first_name

from PERSON p
where p.user_id = (select max(user_id)

                  from PERSON
                  );

select

 p.user_id,
 p.last_name,
 p.first_name

from
 (
  select max(user_id) user_id
  from PERSON
 ) max_p,
 PERSON p
where p.user_id = max_p.user_id;

You have to use an index on user_id, but I think you are already use it....

Regard, Stephan

--

---

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------

Received on Thu Mar 16 2000 - 02:39:01 CST