如何从ASP.NET中的表中获取相同的数据 [英] How to get same data together from table in ASP.NET
本文介绍了如何从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屋!
查看全文