2 6613221154910510141113 661310022017099898 Liang Mou some 2, 201501071215, 201601071221, 440800 n 2017/11/15 15:10:52 Wednesday, 20150114, 4408990067, 302
3 6613221154910510141113 661310022017099898 Liang Mou some 2, 201501071215, 201601071221, 440800 n 2017/11/15 15:12:12 Wednesday, 20150114, 4408990067, 302
4, 6613221154910510141113, 661310022017099898 Liang Mou some 2, 201501071215, 201601071221, 440800 n 2017/11/15 15:13:21 Wednesday, 20150114, 4408990067, 302
5 6613221154910510141113 661310022017099898 Liang Mou some 2, 201501071215, 201601071221, 440800 n 2017/11/15 15:17:52 Wednesday, 20150114, 4408990067, 302
6 6613221154910510141107 661310022017099898 Liang Mou some 2, 201501101625, 201601071626, 440800 n 2017/11/15 15:10:52 Wednesday, 20150117, 4408990067, 302
7 6613221154910510141107 661310022017099898 Liang Mou some 2, 201501101625, 201601071626, 440800 n 2017/11/15 15:13:21 Wednesday, 20150117, 4408990067, 302
8, 6613221154910510141107, 661310022017099898 Liang Mou some 2, 201501101625, 201601071626, 440800 n 2017/11/15 15:12:12 Wednesday, 20150117, 4408990067, 302
9, 6613221154910510141107, 661310022017099898 Liang Mou some 2, 201501101625, 201601071626, 440800 n 2017/11/15 15:17:52 Wednesday, 20150117, 4408990067, 302
CodePudding user response:
First of all, it's my great honor to invite you I answer your question, but, I also have to say you, you are such a topic is according to certain time query statistics this period (20160101-20160601) the frequency of the repeat 2 more times in a week , then push the data below, you said according to a certain period of time, but you this data such as the ha 1 6613221154910510141100 661310022017099898 Liang Mou some 2, 201602071502, 201601071505, 440800 n 2017/11/15 16:18:34 Wednesday, 20160131, 4408990067, 302 there are many similar is the value of time, by which to calculate it, 201602071502 201601071505 2017/11/15 20160131 all of these can be a time ah, details in which to statistics, there is also what you said repetition frequency of two or more times a week , the repeated and should be compared, in which value a have multiple columns, so the above data is the whole data repeat, or a column, or a few columns, didn't say anything, is really helpless ah
CodePudding user response:
Data format is a bit messy, reformat the data and then sent to the other said: under the judgment of repeat 2 times more than what is it?CodePudding user response:
Your data is a bit messy,Train of thought,
With the to_char (to_date (bdate, 'yyyymmddhh24mi'), 'ww) year starting and ending time is calculated in which week
Then the count (*) from table group by whether the same week having the count (*) & gt; 0