Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
how to find count of agent having sum(amount)>10000
Vandana Blogs
Sep 13 2016 6:21 AM
254
Reply
Hello,
I have a problem that how to find count of agents having sum(amount)>10000 with sql query
Teamname
Agentname
Amount
Shweta
Anita
10000
Shweta
Pinky
7000
Shweta
Pinky
3000
Shweta
Pinky
5000
Shweta
Sanjay
12000
Shweta
Kiran
15000
Shweta
Ana
8000
Abnesh
Susmita
7000
Abnesh
Rekha
12000
Abnesh
Vibha
13000
the output must come like this
Teamname
Qualifiers
Shweta
4
Abnesh
2
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
SQL Reporting system.
Remove duplicate records