Re: using MAX function...

create or replace view my_view as
select * from my_table where user_id = (

    select max(user_id) from my_table
);

Of course, substitute your view name for my_view and your table name for my_table.

Kurt

Rookie wrote:

> 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)?
Received on Wed Mar 08 2000 - 18:36:02 CST