#DateForumTypeThreadPost
529 Aug 2014 @ 05:30 PDTDatabaseTopicWhat's the difference between NOT IN and minus in SQL? Hello Experts:   What's the difference between NOT IN and minus  in SQL?    Which is better to use in SQL queries for the performance aspects?
414 Aug 2014 @ 07:01 PDTDatabaseReplyHow to limit rows to only those where there are duplicates of a specific column? select t1.acct,t1.id,t1.code,t2.acct,t2.id,t2.code,t2.row_idnew,t1.row_id,t2.row_idnew-t1.row_id aa, min(t1.code) over(partition by t2.row_idnew-t1.row_id) from (s...
305 Aug 2014 @ 05:20 PDTDatabaseReplywhat is mean by NO CONFIDENCE in teradataThanks Raja
204 Aug 2014 @ 05:59 PDTDatabaseTopicwhat is mean by NO CONFIDENCE in teradataHello Experts: what is mean by NO CONFIDENCE in teradata In the Explain plan of query: The size of Spool 1 is estimated with no confidence to be 2,430,428 rows
127 Jul 2014 @ 01:30 PDTDatabaseTopichexadecimal--->decimal hexadecimal--->decimal    id   16hex    aaa  28E1     Result: id    decimal  aaa   10465