mysql select top 2 1

mysql select top 2

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

Here is what the above code is Doing:
1. Select the x and y columns from the z table
2. Limit the results to the first two records

Similar Posts