Q&A BY TAG 'WHERE CONDITIONS'

You must sign in to ask a question. If you do not have an account, you can register here

Timestamp From 24 Hours Ago of Current Timestamp
answered 05-03-2021 00:47:13 -0500

Hello, I know that I can get the current timestamp using the currenttimestamp function. I wanted to know what is the right way to subtract 24 hours from the timestamp returned from that function, in order to find the timestamp of exactly 24 hours befo...

Answers: 1

local timestamp Date time function WHERE CONDITIONS timestamp

How to use dynamic dates in where clause
answered 27-11-2019 20:11:56 -0500

I am creating a view out of a Teradata database that has the date columns formated as YYYYMM and YYYY-MM-DD. Rather than a date WHERE condition based off of a static date such as '2019-10-31', I want a range based of a dynamics dates such as "ADD_MONTH...

Answers: 1

Dynamic Dates WHERE CONDITIONS

Denodo Cached View Issue (returns 0 records)
answered 18-10-2019 07:33:53 -0400

I am seeing a strange issue with my Denodo cached view where it returns 0 records if I put a where statement and limit the columns. No issue if I select all columns though. Is this a bug, or I am missing the error? Please help me get the tailored view ...

Answers: 5

Query Full Cache WHERE CONDITIONS Cache

WHERE Clause in query
answered 10-01-2018 14:12:41 -0500

I have created dervied view's using Baseview views and query also has an where clause at the end on one the Base view. When I run the new derived view the where condition is executed at the end. I dont see this helping peformance. please let me know, I...

Answers: 1

query plan Sql performance WHERE CONDITIONS

Restrict UDF to WHERE CLAUSE Only
answered 18-11-2016 06:11:15 -0500

Is there a way to apply a restriction on UDF such that it can only be executed in a WHERE Clause, and not at any other place. For example, SELECT UDF(123) FROM DUAL(); ---> It should be invalid SELECT * FROM <TableName> WHERE UDF(COLUMN1) = ...

Answers: 1

UDF WHERE CONDITIONS User Defined Function

Managing Null Array or no result due to where clause in flattening a view
answered 20-07-2015 22:17:37 -0400

I have a view where certain array that I need to flatten may be null or may not contain the specific row that I am looking for. When flattening such array, I get an empty result. How do I manage such array during flattening? Eg. Say I have this data I...

Answers: 7

FLATTEN WHERE CONDITIONS