CREATE TABLE table_1670921_2 (batting_partners VARCHAR2, season VARCHAR2)

What batting partners were the most successful in 2004?
SELECT batting_partners FROM table_1670921_2 WHERE season = "2004"
SELECT "batting_partners" FROM "table_1670921_2" WHERE "2004" = "season"