How to select data from RequestesEmail table based on two co

Question

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 'ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com' , N 'ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com' , '2020-03-17 05:08:11.740' ) INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate]) VALUES ( 39504, N 'ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com' , N 'ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com' , '2019-05-05 05:08:11.740' ) INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate]) VALUES ( 39504, N 'ffgd451d8854b2a824b5446cdd486f2@tw.diodes.com' , NULL , '2020-03-17 05:10:11.740' ) INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate]) VALUES ( 39504, N 'mmoyedb2a824b5446cdd486f2@tw.diodes.com' , NULL , '2020-03-17 05:15:11.740' ) INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate]) VALUES ( 39504, N 'ddlyoyedb2a824b5446cdd486f2@tw.diodes.com' , N 'ddlyoyedb2a824b5446cdd486f2@tw.diodes.com' , '2018-02-09 05:15:11.740' ) all data on table as below EmialRequestID RequestID EmailID ReplyToID EmailDate 1 39502 ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com 2020-03-17 05:08:11.740 2 39504 ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com 2019-05-05 05:08:11.740 3 39504 ffgd451d8854b2a824b5446cdd486f2@tw.diodes.com NULL 2020-03-17 05:10:11.740 4 39504 mmoyedb2a824b5446cdd486f2@tw.diodes.com NULL 2020-03-17 05:15:11.740 5 39504 ddlyoyedb2a824b5446cdd486f2@tw.diodes.com ddlyoyedb2a824b5446cdd486f2@tw.diodes.com 2018-02-09 05:15:11.740 desire result is EmialRequestID RequestID EmailID ReplyToID EmailDate 1 39502 ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com 17/03/2020 3 39504 ffgd451d8854b2a824b5446cdd486f2@tw.diodes.com NULL 17/03/2020 4 39504 mmoyedb2a824b5446cdd486f2@tw.diodes.com 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 ?

Pankaj Patel · 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 yenumula · Answer

SELECT * FROM RequestsEmail WHERE (ReplyToID IS NULL ) or EmailId in ( select EmailId from RequestsEmail where ReplyToId is not null ) AND CAST (EmailDate AS DATE ) = CAST (GETDATE() as DATE )