#DateForumTypeThreadPost
8709 Jun 2015 @ 07:47 PDTGeneralTopicHOW TO GET ODD NUMBER ROWS IN A TABLE IN TERADATAHi everyone,   Could you please attach the query for getting the odd rows in a table; eg : id name sal         1 puru   2000k        2 ki...
8608 Jun 2015 @ 12:18 PDTGeneralTopicNeed help I have a table : Name        Mobile          Buy_date                         Hari   &...
8508 Jun 2015 @ 12:18 PDTGeneralTopicNeed help I have a table : Name        Mobile          Buy_date                         Hari   &...
8405 May 2015 @ 02:09 PDTGeneralTopicCould anyone please explain me about master data in teradataHi All, Could anyone please explain me about master data...   I am new to teradata. Expecting the response from you soon..   Regards, Purushotham.    
8321 Apr 2015 @ 01:37 PDTDatabaseReplyHow to find the associated tables or view in teradata?HI, could be pls explain me use of QUALIFIED .. without using qualified also we can get :SHOW TABLE <TABLE_NAME> OR sel * from dbc.tables where requexttext like '%table_name%'
8215 Apr 2015 @ 06:58 PDTGeneralReplyhow to delete top 5 salary from employee tableThank u so much sravan... I tried the above code which u shared is working fine.. Regards, Purushotham.
8112 Apr 2015 @ 06:57 PDTGeneralTopichow to delete top 5 salary from employee tableHi Experts, could you please share me how to delete top 5 salary from employee table. Thanks in advance.. Regards, Purushotham.
8026 Mar 2015 @ 06:55 PDTGeneralTopicI am new to stored procedures.In my current project they are using stored procedures for loading from stg to target table.Hi , Could you pls share something abt stored proceures and if any issue occured while executing stored procedures.how to resolve and what is the approach to resolve those issues.. Thanks...
7926 Mar 2015 @ 06:48 PDTGeneralReplyIn a column i have alpha numeric values,but i need to display only alphabets .could anyone please share me the query...I am using Teradata 13.0 version. Regards, Purushotham M
7826 Mar 2015 @ 06:47 PDTGeneralTopicIn a column i have alpha numeric values,but i need to display only alphabets .could anyone please share me the query...Hi, Could anyone pls help me out in this secanerio.... Thanks... Regards, Purushotham M
7708 Nov 2014 @ 07:44 PSTGeneralTopicIN Realtime in which scenaries we will get a table does not exist error?
7608 Nov 2014 @ 06:57 PSTGeneralTopicwhat is the use of sel CHAR2HEXINT(COL2) FROM TABLENAME?COULD ANYONE PLS EXPLAIN ME.I create a table with columns as: create table puru_n(id int,name char(10),salary int); if i insert data into table(10,'abc   ',20000); there is a space in the second field; then i ...
7528 Oct 2014 @ 05:16 PDTGeneralTopicIf we create a 32 secondary indexes on table what might be the performanceHi Everyone,   If we create a 32 secondary indexes on a table whether in decreases performance or not? Regards, Purushotham..            
7428 Oct 2014 @ 05:07 PDTGeneralTopicwhat are the drawbacks by using join index table?
7316 Oct 2014 @ 01:47 PDTGeneralTopicCould anyone pls tell me how can we get sorted results without using order by clauseHi Everyone,   Could anyone please tell me how can we get sorted result without using ORDER BY CLAUSE... hope i can get answer soon from you....   Regards, Purushotham  
7208 Oct 2014 @ 02:37 PDTGeneralTopichow to create new table as old table and aditionally two columns in new table?
7130 Sep 2014 @ 04:46 PDTGeneralTopicHOW TO FIND THE FIRST 20 WORST RUNNING QUERIES LISTS IN TERADATAHi Everyone, Could anyone please help me how to find the worst running queries lists in teradata? Hope i will get the response soon....   Regards, Purushotham.  
7016 Sep 2014 @ 12:16 PDTGeneralReplyHOw to drop a particular Partition in partition tableHi Raja, AS you provided the link, i tried it but  I am getting an error. Eg : ALTER TABLE PPI MODIFY DROP RANGE BETWEEN DATE '2014-01-13' AND DATE '2014-01-31'.If i tried i ...
6915 Sep 2014 @ 10:04 PDTGeneralReplyHOw to drop a particular Partition in partition tableHi Raja, If a table is not empty,can we drop a particular Partition.   Thanks for your reply.. Regards, Purushotham
6815 Sep 2014 @ 08:01 PDTGeneralReplyHOw to drop a particular Partition in partition tableHi,   From the above table,  I want to create a Partition on ID column. In partition definition what should i specify in Each interval ?  
6715 Sep 2014 @ 07:58 PDTGeneralTopicHOw to drop a particular Partition in partition tableHi Everyone, Can anyone pls how to drop a Particular partition in Partition Primary index table.   ex: CREATE TABLE PURU_TAB,FALLBACK(ID INT,NAME CHAR(10),DOB DATE)PRIMARY INDEX(ID) PARTIT...
6615 Sep 2014 @ 06:51 PDTDatabaseReplyrowkeyHI Everyone,   Could anyone please tell me size of Rowkey size..   Regards, Purushotham
6502 Sep 2014 @ 10:18 PDTGeneralTopicWithout using Join keyword how can we retrive matching rows from both the tablesHi,   Could anyone pls share me a query .without  using join keyword  how can we retrive the matching rows from both the tables..   Regards, Purushotham..  
6402 Sep 2014 @ 10:09 PDTGeneralTopicCan anyone please tell me use of merge block ratio in ddlsHi Everyone,   use of Default Merge block Ratio in DDl's      
6308 Jul 2014 @ 08:50 PDTGeneralTopicReasons for Product Join..Hi, Could anyone pls me reasons for Product Join. In which Scenaries the query uses product join.Please share me some reasons....   Regards, Purushotham.M

Pages