Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
7
Reply
How to find Record Compare to Month Product?
HARDIK BHAVSAR
Nov 25 2013 12:26 AM
1.8k
Reply
How to create a query when i give the month name same as product record display in amount otherwise not match product are not display in record?
EXAMPLE :-
Product Name
Month
Amount
ABCD
5
20000
XYZ
5
10000
Kapchi
5
4500
RETI
5
65000
Jab Tak Hai Jaan
5
30000
Jab Tak Hai Jaan
6
30000
ABCD
6
20000
XYZ
6
10000
Kapchi
7
1000
RETI
7
45000
ABCD
8
20000
XYZ
8
10000
RETI
8
45000
Jab Tak Hai Jaan
8
30000
Kapchi
9
1000
GIVE OUTPUT :-
Product Name
Month
Amount
Kapchi
5
4500
RETI
5
65000
Kapchi
7
1000
RETI
7
45000
RETI
8
45000
Kapchi
9
1000
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
7
)
Next Recommended Forum
what is the difference between 'having' and 'where' clause ?
how to use subquery?