SELECT TOP 1 *
  from People
 WHERE LastName < 'Doe' or LastName = 'Doe' and FirstName < 'Joe'
 ORDER BY Previous.LastName DESC, Previous.FirstName DESC