Re: using MAX function...

>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)?
>
>Hi,

One way to do it is:
SELECT MAX(user_id),first_name,last_name FROM table_name
GROUP BY user_id,first_name,last_name;
HTH
Sandy

>
>
>
>
>
>
Received on Wed Mar 08 2000 - 15:10:48 CST