SELECT Count(Distinct (Emply_number) FROM Employ table where
WHERE LOG_TS BETWEEN
(TIMESTAMP(CURRENT DATE- 02 days ,'00:00')-
AND (TIMESTAMP(CURRENT DATE - 02 DAYS,'00:00')- 1 MICROSECOND) WITH UR;
I have this query .but i need someone to help with this condition : for particular date ( current date-2) .I tried many scenarios for this,but not able to find the exact condition.
Well, your "query" has two sets of unbalanced parentheses, an improperly repeated keyword, an typographical error, and an apparently missing duration, any of which would prevent it for running; therefore, this isn't the SQL that you're actually using. Since we can't literally hold your feet to the fire to get the truth out of you, we can't help and I won't try.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day