使用带有LIMIT 10的SQL ORDER BY子句从数据库中选择前10个元素。
语法如下SELECT *FROM yourTableName ORDER BY yourIdColumnName LIMIT 10;
为了理解上述语法,让我们创建一个表。创建表的查询如下mysql> create table Clients
- > (
- > Client_Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
- > ClientName varchar(20)
- > );
使用insert命令在表中插入一些记录。
查询如下mysql> insert into Clients(ClientName) values('Larry');
mysql> insert into Clients(ClientName) values('Sam');
mysql> insert into Clients(ClientName) values('Bob');
mysql> insert into Clients(ClientName) values('David');
mysql> insert into Clients(ClientName) values('John');
mysql> insert into Clients(ClientName) values('James');
mysql> insert into Clients(ClientName) values('Robert');
mysql> insert into Clients(ClientName) values('Carol');
mysql> insert into Clients(ClientName) values('Mike');
mysql> insert into Clients(ClientName) values('Maxwell');
mysql> insert into Clients(ClientName) values('Chris');
mysql> insert into Clients(ClientName) values('Ramit');
使用select语句显示表中的所有记录。
查询如下mysql> select *from Clients;
以下是输出+-----------+------------+
| Client_Id | ClientName |
+-----------+------------+
| 1 | Larry |
| 2 | Sam |
| 3 | Bob |
| 4 | David |
| 5 | John |
| 6 | James |
| 7 | Robert |
| 8 | Carol |
| 9 | Mike |
| 10 | Maxwell |
| 11 | Chris |
| 12 | Ramit |
+-----------+------------+
12 rows in set (0.00 sec)
这是选择前10个元素的查询mysql> select *from Clients ORDER BY Client_Id LIMIT 10;
以下是输出+-----------+------------+
| Client_Id | ClientName |
+-----------+------------+
| 1 | Larry |
| 2 | Sam |
| 3 | Bob |
| 4 | David |
| 5 | John |
| 6 | James |
| 7 | Robert |
| 8 | Carol |
| 9 | Mike |
| 10 | Maxwell |
+-----------+------------+
10 rows in set (0.00 sec)
这是选择前10个元素的替代查询。
查询如下mysql> select *from Clients limit 0,10;
以下是输出+-----------+------------+
| Client_Id | ClientName |
+-----------+------------+
| 1 | Larry |
| 2 | Sam |
| 3 | Bob |
| 4 | David |
| 5 | John |
| 6 | James |
| 7 | Robert |
| 8 | Carol |
| 9 | Mike |
| 10 | Maxwell |
+-----------+------------+
10 rows in set (0.00 sec)