Re: Beginner's question

In article <ecSp03Brcazg00_at_amdahl.uts.amdahl.com> rtan@.uts.amdahl.com (Rick Tan) writes:

> I need to retrieve a row from a table. The row selected must have the
> largest value in a field. What SQL statement will do the trick?
> Thanks in advance for any help.
 

> Rick

Try select max(field), other_field, other_field_2 from your table;

--

  DISCLAIMER?  I don't know anything 'bout any ol' disclaimer!         

+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+
| David Rackley                 |                                             |
| Applied Research Laboratories |      It's OK to be a martyr, as long as     |
| The University of Texas       |      you don't bring your own firewood.     |
| Austin, TX.  78758            |                          -- Dr. James Rigby |
| Tel: 512-835-3120             |                                             |
+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+