|
View previous topic :: View next topic
|
| Author |
Message |
aryanpa1
New User
Joined: 26 May 2007
Posts: 45
Location: Chennai
|
|
|
|
Hi Team ,
How can we retrieve the rows in which particular field is repeated more than n times.
For Example.
| Code: |
STU_NAME STU_NUMBER STU_MARKS
AAAAA-----11111----------50
BBBBB-----22222----------50
CCCCC----33333----------60
DDDDD----44444----------50
EEEEEE-----55555----------60 |
In this scenario I need to get the rows which are having same marks for more than 2 rows.
Expected rows are with STU_NAME s AAAAA,BBBBB,DDDDD
Edited: Please use BBcode when You post some code, that's rather readable...Anuj |
|
| Back to top |
|
 |
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
aryanpa1
New User
Joined: 26 May 2007
Posts: 45
Location: Chennai
|
|
|
|
| Thank you Anuj. It is working. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
You're welcome.. 
-Ad |
|
| Back to top |
|
|
|
|
