Answer / santosh

Hi Friends some addition to 'Chelvam' ans.

SELECT C1 FROM <TABLE_NAME> WHERE UPPER(C1) =
C1(CASESPECIFIC) AND LOWER(C1) = C1(CASESPECIFIC)

Answer / chelvam

select C1,
CASE WHEN ( C1( UPPERCASE) = C1(CS) ) THEN
'NUMERIC'
ELSE
'ALPHANUMERIC'
END as C11
from TableName;

Answer / tdguy

Assuming the column to be char(2), we can use the following
sql to retrieve the numeric values.

SEL C1 FROM
(SEL C1,
CASE
WHEN SUBSTR(C1,1,1) IN
('1','2','3','4','5','6','7','8','9','0')
THEN 'N'
WHEN SUBSTR(C1,1,1) IN (' ')
THEN 'S'
END AS ONE,
CASE
WHEN SUBSTR(C1,2,1) IN
('1','2','3','4','5','6','7','8','9','0')
THEN 'N'
WHEN SUBSTR(C1,2,1) IN (' ')
THEN 'S'
END AS TWO FROM STUD2
) A
WHERE ((A.ONE='N' AND A.TWO='N')
OR
(A.ONE='N' AND A.TWO='S')
OR
(A.ONE='S' AND A.TWO='N'))

Answer / parthi

SELECT * FROM C1
WHERE TD_SYSFNLIB.TO_NUMBER(C1) IS  NOT NULL;

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

0 Answers  

---

Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 Answers  

---

Define views in teradata with syntax.

0 Answers  

---

can we join volatile table with general table an global temporary table with general table ?

4 Answers   IBM,

---

What is teradata? Also, list out some of the primary characteristics of teradata.

0 Answers  

---

What are the functions performed by bynet?

0 Answers  

---

what are the roles and responsibilities of teradata DBA ?

1 Answers   TCS,

---

what is the query for retrieve the unique values(not display the duplicates values) from single table?

6 Answers   IBM,

---

suppose one Cylinder split data blocks are moved from where?

1 Answers  

---

what is identity columns in TD?

2 Answers   Wipro,

---

What are the design features involved in teradata?

0 Answers  

---

What is stored procedure in teradata?

0 Answers  

---