Tags for where
Querying the data between 2014 and current date
Hi all, I have some problem about the query which finds the data between 2013-12-31 and today I took invalid timestamp error. The query I used looks like this: select * from table1 where the_date between '2013-12-31' and current_time   Please help me!  
Quer where invalid timestamp
how to query large rows in Teradata SQL?
Hi   I am new to Teradata SQL; I have a database containing 10 million records(rows) of revenue, each with a unique ID. I need to query 3 million records out of it, in which I do have the IDs of these 3 million records. the direct and slowest way would be:select ID, revenuefrom My_Table
where big data
ON and WHERE clause for Joins
Hi, I have a doubt when coding ON and WHERE clause for Joins (Inner Vs Outer).   I think, for an Inner Join its does not make a difference whether we apply the condition with ON cluase or WHERE cluase.   Please refer the 2 queries belows-   sel customer_id,customer_name,order_amount
on where outer join
Improve performance of like queries.
Hi All,     Is there anyway to improve the performance(Reducing the CPU consumed is the main aim for now) of queries involving like in the where clause.     WHERE FIRST_NM LIKE :V_FIRST_NM||'%' AND LAST_NM LIKE :V_LAST_NM||'%';
performance where like
How to parametrize WHERE IN clause in stored procedure?
I'm trying to parametrize a stored procedure, which takes one input string parameter and use it in the where clause in dynamic cursor. The following snippet works with one parameter but when the list is like "US,GE", then it fails..
stored procedure sp where parametrize in
difference between having a filter condition in the where clause as against a on join clause
Hello everyone,   I have SQL question, about how does having a filter condition like (say) prod_cat = 7980 in the following two conditions will be treated 1. In a where clause of multiple joins     something like a inner join b                                on [join cond]
join on where clause