Solved: Re: Possible to use where clause in SQL select sta... - Qlik Community

ferha_jafri · ‎2015-07-21

Hello Everyone,

I have an issue in which I want to select only last 2 days data from the server table not sure how to use where clause in sql select statement.

Thank you

Regards

Ferha

tresesco · ‎2015-07-21

Something like:

SELECT *

FROM TABLE_NAME

WHERE Date_Column >= DATEADD(DAY, -2, GETDATE())

View solution in original post

tresesco · ‎2015-07-21

Something like:

SELECT *

FROM TABLE_NAME

WHERE Date_Column >= DATEADD(DAY, -2, GETDATE())

PrashantSangle · ‎2015-07-21

Hi,

Try

select *

From TableName

Where trunc(dateField)>=trunc(sysdate()-2);

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Kushal_Chawda · ‎2015-07-21

What is the source database?

Possible to use where clause in SQL select statement