订购日期记录并在MySQL中获取第二条有序记录
要进行排序,请使用ORDERBY并仅获取第二个有序记录,并使用MySQLLIMIT并设置偏移量。让我们首先创建一个-
mysql> create table DemoTable1417 -> ( -> CustomerId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> CustomerName varchar(20), -> ShippingDate date -> );
使用insert在表中插入一些记录-
mysql> insert into DemoTable1417(CustomerName,ShippingDate) values('Chris','2019-01-21'); mysql> insert into DemoTable1417(CustomerName,ShippingDate) values('David','2018-12-01'); mysql> insert into DemoTable1417(CustomerName,ShippingDate) values('Carol','2019-09-28'); mysql> insert into DemoTable1417(CustomerName,ShippingDate) values('Sam','2019-08-29');
使用选择显示表中的所有记录-
mysql> select * from DemoTable1417;
这将产生以下输出-
+------------+--------------+--------------+ | CustomerId | CustomerName | ShippingDate | +------------+--------------+--------------+ | 1 | Chris | 2019-01-21 | | 2 | David | 2018-12-01 | | 3 | Carol | 2019-09-28 | | 4 | Sam | 2019-08-29 | +------------+--------------+--------------+ 4 rows in set (0.00 sec)
这是获取第二个有序记录的查询-
mysql> select CustomerName,ShippingDate from DemoTable1417 order by CustomerId limit 2,1;
这将产生以下输出-
+--------------+--------------+ | CustomerName | ShippingDate | +--------------+--------------+ | Carol | 2019-09-28 | +--------------+--------------+ 1 row in set (0.00 sec)