Best way to retrieve a row? (fetchrow)

Hello.

What is the best way to retrieve a specific row from a SELECT return (in Perl DBI)?
For example, if I have a table with

First Name Last Name Phone #
First Name Last Name Phone #
First Name Last Name Phone #

If I wanted to access the information in the third row, what is the most efficient way to do this? (Right now, I am using a while loop, going through and fetching the row 3 times)

Thanks! http://www.datera.com

use Select statement with where condition.

If you add a sno (auto_increment) field in your database,you can perform this kind of action very easliy with select query.

"SELECT * FROM tblname where sno=3"