How can Iselect records from a school staff table acording to highest designation first, like first principle than vice principle than faculty etc?
How can I select records from a school staff table acording to highest designation first, like first principle than vice principle than faculty etc?