how to find continuous row of same value
Hi,
I need to help, is there way in mysql to find out my expected result.
below is case.
Suppose I have table user as display below. I want such result which are having continuous same amount for 3 time i.e. I should get continuous first three record. here I am trying to find result by mobile number. If continuous same amount is not available in table(3 times) for number then that record will not come in result set.
User
id | name | amount | mobile Number
1 | new | 10 | 99999999
2 | new | 10 | 99999999
3 | new | 10 | 99999999
4 | new | 20 | 99999999
5 | new | 10 | 99999999
6 | new | 10 | 99999999
Subject
Written By
Posted
how to find continuous row of same value
May 19, 2016 08:05AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.