Get Previous Day Distinct Records in SQL Server

bhadriau

SOLVED CLOSED ACTIVE ANSWERED
User: bhadriau
Posted: on Jun 27, 2016 03:36 AM
Forum: SQL Server
Answer: 2
Views: 3373

Dear All,

Could you please let me know How do I get the result for " Report contains all users added the previous day"

Here I want to know make the where condition on "Createddate" column on yesterday date i.e DD:MM:YYYY:00:01:00 (AM) and DD:MM:YYYY:11:59:00 (PM)

I am new to teh SQL , please help me

Table1

FName   LName             Createddate
HGHG      A                    25:06:2016:00:10:000
JHGJ        B                   25:06:2016:01:18:000
JHGJ         C                  25:06:2016:06:10:000

Download FREE API for Word, Excel and PDF in ASP.Net

bhadriau

0 4

Reply
ANSWER
User: bhadriau
Replied: on Jun 27, 2016 04:07 AM
Report

Thank you so much for your response, here I don't want to hard code any thing like @Date,

Here is my query, Could you please et me know is that OK.

SELECT CreateDate,FName,LName,Number FROM Users1 WHERE CreateDate in ( SELECT MAX(CreateDate) from Users1 group by Number)

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Get Previous Day Distinct Records in SQL Server

Company

Explore

Follow us

Contact Us