How will sql for this condition look like (if else if else like situation)
===

I have three fields in a table:


    score  status  No.
    1,     2,      1
    0,     1,      2
    0,     0,      1


I need this, to write a C# style pseudo SQL:    

    rows = empty;

    rows = "SELECT * FROM `table` WHERE score = 1"
    if (rows.Count > 0) //at least one row
        return rows;

    rows = "SELECT * FROM `table` WHERE status = 2"
    if (rows.Count > 1) //more than one row 
        return row with MAX(No.);
    
     return rows;

I hope I could be clear. In short, select from my table a record with score = 1, and if there isn't such a record, return the record where status = 2 and if there are more than one record with status = 2, then return the record with maximum value for No. (if no record at all with status = 2, return empty). 

How can I write it in one query? It should be a good learning experience for me. Otherwise I know to breakup into smaller queries and run each one..