1.2.2.10.Limiting the Data Retrieved Using LIMIT

  • 限制查詢的個數

select * from StudentsDetails limit 5;

  • 限制查詢的個數, 並指定起算的index

select * from StudentsDetails limit 5, 5;
Previous1.2.2.9.Sorting the Data Using ORDER BYNext1.2.2.11.Updating or Modifying Data in a Table Using UPDATE

Last updated

Was this helpful?