On Mo, 1999-09-13 19:01:34 -0500, Ted <r_m_m@stripped> wrote:
> My question is how to write a SQL statment that can select only the
> forth row of data from the table. In row 1,2,4 they have the same
> Name and Group, but different age to identify they are not the same
> person. (this is a dummy data, it might make no sense to you) My
> expected result is selecting only the row 4th.
Did you already have a look at chapter "8 MySQL Tutorial" of the MySQL
Reference Manual? There are some example queries for different tasks.
I guess chapter "8.3.2 The row holding the maximum of a certain column"
is what you need here ...
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7