How to select data from RequestesEmail table based on two co

How to select data from RequestesEmail table based on two condition on same time ?

I work on SQL server 2012

I have table request emails register email requested and replies

structure table as following :

CREATE TABLE [dbo].[RequestsEmail](
[EmialRequestID] [int] IDENTITY(1,1) NOT NULL,
[RequestID] [int] NULL,
[EmailID] [nvarchar](250) NULL,
[ReplyToID] [nvarchar](250) NULL,
[EmailDate] [datetime] NULL,
) ON [PRIMARY]
INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate])
VALUES ( 39502, N'[email protected]', N'[email protected]','2020-03-17 05:08:11.740')
INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate])
VALUES ( 39504, N'[email protected]', N'[email protected]','2019-05-05 05:08:11.740')
INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate])
VALUES ( 39504, N'[email protected]', NULL,'2020-03-17 05:10:11.740')
INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate])
VALUES ( 39504, N'[email protected]', NULL,'2020-03-17 05:15:11.740')
INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate])
VALUES ( 39504, N'[email protected]', N'[email protected]','2018-02-09 05:15:11.740')

all data on table as below

EmialRequestID RequestID EmailID ReplyToID EmailDate

3 39504 [email protected] NULL 2020-03-17 05:10:11.740

4 39504 [email protected] NULL 2020-03-17 05:15:11.740

desire result is

EmialRequestID RequestID EmailID ReplyToID EmailDate

3 39504 [email protected] NULL 17/03/2020

4 39504 [email protected] NULL 17/03/2020

Actually i need to make select statement display or show all data on table RequestEmail above structure

where

first condtition

ReplyToID is null and EmailDate equal datetoday

and also second condition

select EmailID where equal ReplyToID and EmailDate is dateToday

two condition on same time must show .

so how to do that please ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankajkumar Patel6y ago
Accepted answer
Hi Ahmed Elbarbary,

To apply two condition on same time you can use OR as like following:
SELECT * FROM RequestsEmail
WHERE (ReplyToID IS NULL AND CAST(EmailDate AS DATE) = CAST(GETDATE() as DATE))
OR
(EmailID = ReplyToID AND CAST(EmailDate AS DATE) = CAST(GETDATE() as DATE))
Hope, this will help you!
nagaraju yenumula6y ago
1. SELECT * FROM RequestsEmail
2. WHERE (ReplyToID IS NULL) or EmailId in(select EmailId from RequestsEmail where ReplyToId is not null)
3. AND CAST(EmailDate AS DATE) = CAST(GETDATE() as DATE)