How to reterive an data from sql on the basis of month and year id

Question

0.00/5 (No votes)

See more:

Hello,

I have an problem that,

I have an table that consist of Amount(decimal),MonthId(Int),Year(int)

and I want to reterive an sum of amount between 4(Month),2013(Year) to 3(Month),2014(Year) through query.

Please,any one can suggest me how to do this..

Posted 5-May-14 18:27pm

ajays3356

Add a Solution

Comments

Ajith K Gatty 6-May-14 1:39am

Hi Ajay,

try solution 1 and 2.
If you have date a column you can easily implement BETWEEN Operator.
Ex: SELECT * FROM Orders
WHERE OrderDate BETWEEN #07/04/1996# AND #07/09/1996#

Good Luck.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2014-05-05T18:44:00

Solution 1

Try
select * from table where (Year >= 2013 and Month >=4) AND (Year <= 2014 and Month <=3)

Posted 5-May-14 18:44pm

Abhinav S

Updated 5-May-14 18:45pm

v2

Comments

ajays3356 6-May-14 0:49am

i have try this,it gives null,But i have columns in table

But i want all the column Between 4,2013 and 3,2013

Laiju k 6-May-14 1:01am

please check whether you have mentioned the database or not

ajays3356 6-May-14 1:11am

I have mention the database.

Bh@gyesh · Answer 2 · 2014-05-05T19:01:00

Solution 3

Hi,

Try following solution :

SQL

select SUM(amt) from
(
sELECT SUM(amount) amt FROM test1 WHERE ([month]>=3 and [year]=2013)
union
select sum(amount) amt from test1 where ([month]<=3 and [year]=2014)
) test

Change your year and month accordingly.

Posted 5-May-14 19:01pm

Bh@gyesh