mysql - I want to get a SQL query for my asp.net -
here's table:
firstname |lastname |gender | age fname1 |lname1 | male | 23 fname2 |lname2 | male | 22 fname3 |lname3 | male | 20 fname4 |lname4 | female | 19 fname5 |lname5 | female | 22 fname6 |lname6 | female | 17
i want select 1 value such when set gander = male
should first , last name of male lowest age.
if want select second lowest age person of gender = male
should one, , female.
for lowest
select * `test` gender='male' order age asc limit 0,1;
for second lowest
select * `test` gender='male' order age asc limit 1,1;
Comments
Post a Comment