如何从ASP.NET中的表中获取相同的数据 [英] How to get same data together from table in ASP.NET

问题描述

你好，我的标题可能不清楚，但我的问题是：

i我的sqltable中有一些数据

例如

Hello, my title may be not clear but my problem is:
i have some data in my sqltable
eg

index	timedata	field1	field2
1	31/10/2017 00:00	a	x
2	01/11/2017 00:00	a	x
3	02/11/2017 00:00	a	x
4	03/11/2017 00:00	b	y
5	04/11/2017 00:00	b	y
6	05/11/2017 00:00	b	y
7	06/11/2017 00:00	a	x
8	07/11/2017 00:00	a	x

在这个数据中我想将1,2,3一起编号4,5,6和7,8一起

field1和field2用于where claues

我的最终结果应该是

in this data i want to index 1,2,3 together 4,5,6 together and 7,8 together
field1 and field2 are used for where claues
my final result should be

index	from date	          todate	field1	field2
1	31/10/2017 00:00	02/11/2017 00:00	a	x
2	03/11/2017 00:00	05/11/2017 00:00	b	y
3	06/11/2017 00:00	07/11/2017 00:00	a	x

这里1,2,3和7,8的结果不应该混合



什么我试过了：



i我在sqldataadapter中获取数据

here result of 1,2,3 and 7,8 should not mix

What I have tried:

i am fetching data in my sqldataadapter

推荐答案

你可以尝试以下查询，



选择rownumindex，time_stamp，field1，field2来自

（

选择min（indexnum）indexnum，min（time_stamp）time_stamp，field1，field2
来自table_name的


group by field1，field2

）a;

you can try following query,

select rownum "index",time_stamp,field1,field2 from
(
select min(indexnum) indexnum,min(time_stamp) time_stamp,field1,field2
from table_name
group by field1,field2
) a;

以下链接值得研究。请尝试以下技巧。

sql - 如何在此表中找到重复的连续值？ - 堆栈溢出 [ ^ ]

sql - 如何根据列的值查找连续的行？ - Stack Overflow [ ^ ]

sql server - 在SQL中计算连续的重复值 - Stack Overflow [ ^ ]

Below links are worth looking into. Please try below tricks.
sql - How can I find duplicate consecutive values in this table? - Stack Overflow[^]
sql - How to find consecutive rows based on the value of a column? - Stack Overflow[^]
sql server - Count consecutive duplicate values in SQL - Stack Overflow[^]

这篇关于如何从ASP.NET中的表中获取相同的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！