What are the players whose rank is 2?
CREATE TABLE "most_dismissals_in_a_career" (
  "rank" real,
  "dismissals" real,
  "player" text,
  "nationality" text,
  "catches" real,
  "stumpings" real,
  "career_span" text
);
SELECT "player" FROM "most_dismissals_in_a_career" WHERE "rank"=2;