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

Popular posts from this blog

amazon web services - S3 Pre-signed POST validate file type? -

c# - Check Keyboard Input Winforms -