SELECT x,y FROM z LIMIT 0,2; // the first value in limit corresponds to start index, // the second value is the number of records to show