How to check condition for same field in my SQL?

Question

0.00/5 (No votes)

See more:

Hi Team,

Following is the table:

ECNO	BRANCH	MONTH	ISDELETED
1	B1	February 2018	n
2	B3	February 2018	n
3	B3	March 2018	n
4	B1	March 2018	n
5	B2	January 2018	n
6	B3	January 2018	n

Here we need to select according to branch and starting date and end date.

Case1:
If branch is B3, starting date and end date is equal then
pick according the branch selected.

select * from HR_BULKBILL_DETAILS where BRANCH='B3' AND MONTH='March 2018'

This query works fine

Case 2:
If Staring date (Assume January 2018) and End date (Assume Febuary 2018) And Branch b3. How to check this condition in select query

How Check two condition for one field?

Note: (In database we have only column Month:this hold month- year example : Januray 2018)
I am using my sql.

What I have tried:

select * from HR_BULKBILL_DETAILS where  MONTH='February 2018' AND MONTH='March 2018' AND BRANCH='B3'

Posted 20-Feb-18 18:39pm

Sissy Ram

Updated 20-Feb-18 19:08pm

v2

Add a Solution

Comments

Sissy Ram 21-Feb-18 0:57am

Forgive me if any typo.
My Expected Output is:
ECNO BRANCH MONTH ISDELETED 2 B3 February 2018 n 3 B3 March 2018 n
My Input is user give startedate and end date and brach
Startdate and enddate will be like March 2018

1 solution

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)

Sissy Ram · Accepted Answer · 2018-02-20T19:09:00

Solution 1

Finally I got result by using "between"
Following is the query:
select * from HR_BULKBILL_DETAILS where MONTH Between 'February 2018' AND 'March 2018' and BRANCH='B3'

Posted 20-Feb-18 19:09pm

Sissy Ram