查找给定表中的第一个和最后一个记录 [英] To find the first and last records in a given table

问题描述

heyy ......





我想查询，查找给定表格中的第一个和最后一个记录但我想要某些条件的结果..



这里是我的表数据：

heyy...


I want a query, to find the first and last records in a given table but I want the result by some condition..

here is my table data :

No.       starttime  Endtime
-------   ---------  --------
0500000001  06:52   06:59
0500000001  07:00   07:27
0500000001  07:28   08:09
0500000001  08:14   08:40
0500000001  08:42   10:00
0500000001  10:01   11:29
0500000001  11:31   12:41
0500000001  12:43   13:28
0500000144  10:59   11:03
0500000144  11:03   11:04
0500000144  11:05   11:07
0500000144  11:08   11:37
0500000144  11:37   09:47
0500000144  09:47   09:51
0500000144  09:52   09:53
0500000144  09:54   10:46
0500000144  10:47   11:12
0500000144  11:13   11:16
0500000144  11:17   13:02
0500000144  13:02   09:29
0500000144  13:29   09:29

这里我希望我的结果像这样

here I want My result as like this

No.          starttime     Endtime
  ------        ----------   --------
  0500000001    06:52         13:28
  0500000144    10:59         09:29

ie。第一条记录和最后一条记录号



任何想法如何在mysql中编写查询...？

ie. first record and last record of No.

Any idea how to write query in mysql...?

推荐答案

你 Google [ ^ ]它？

尝试这种格式..

获得第一条记录：

Do you Google[^] it?
Try in this format..
To get the first record:

select col1,col2,col3 from tab1 order by col1 asc limit 1;

获取最后一条记录：

To get the last record:

select col1,col2,col3 from tab1 order by col1 desc limit 1;

试试这样

Try like this

DECLARE @Vehicle TABLE (
VehicleNo NVARCHAR(50),Datetime1 Datetime,Datetime2 Datetime);
INSERT INTO @Vehicle (VehicleNo,Datetime1,Datetime2)
VALUES('0500000001','06:52','06:59')
INSERT INTO @Vehicle (VehicleNo,Datetime1,Datetime2)
VALUES('0500000001','07:00','07:27')
INSERT INTO @Vehicle (VehicleNo,Datetime1,Datetime2)
VALUES('0500000144','10:59','11:03')

SELECT top 1 * FROM @Vehicle WHERE VehicleNo=(SELECT MIN(VehicleNo) FROM @Vehicle)
UNION
SELECT top 1 * FROM @Vehicle WHERE VehicleNo=(SELECT MAX(VehicleNo) FROM @Vehicle)

http://stackoverflow.com/questions/2735395/how-to-find-first -and-last-record-from-mysql-table



get-the-last-last-last-record-of-db [ ^ ]



检查链接..希望它有帮助..

http://stackoverflow.com/questions/2735395/how-to-find-first-and-last-record-from-mysql-table

get-the-first-and-last-record-of-db[^]

Check the link..hope it will help..

这篇关于查找给定表中的第一个和最后一个记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！