The fetchone() method returns the next row of a query result set or None if there are no more rows. The fetchall() method returns all rows of a query result set as a list of tuples.