i have two records in select query and it have a two record, then how can i found second record from the result of select query in mysql

[Quoted] i have a patient table with details of first name, lastname, date of birth, gender.

my query,
select first_name, last_name from patient_details where id in (select id from patient_details where last_name = 'madison');

it's gave multiple records, then how can found the second record from the result and how to display the that particular data

Thanks in advance Received on Fri Apr 14 2017 - 07:06:02 CEST