MySQL Forums
Forum List  »  General

how to find continuous row of same value
Posted by: manoj meshram
Date: May 19, 2016 08:05AM

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

Options: ReplyQuote


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.