topic Re: Possible to use where clause in SQL select statement in QlikView

Possible to use where clause in SQL select statement

ferha_jafri — Tue, 21 Jul 2015 05:14:29 GMT

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

tresB — Tue, 21 Jul 2015 05:27:30 GMT

Something like:

SELECT *

FROM TABLE_NAME

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

PrashantSangle — Tue, 21 Jul 2015 05:32:40 GMT

Hi,

Try

select *

From TableName

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

Regards

Kushal_Chawda — Tue, 21 Jul 2015 05:36:16 GMT

What is the source database?