CREATE TABLE table_23316034_23 (dismissals NUMBER, player VARCHAR2)

Name the least dismissals for sammy carter
SELECT MIN(dismissals) FROM table_23316034_23 WHERE player = "Sammy Carter"
SELECT MIN("dismissals") FROM "table_23316034_23" WHERE "Sammy Carter" = "player"