Tagged Questions

0
votes
1answer
12 views

get rid of zeros after decimal point

Hi All, select CAST(MIN(column_1) AS DECIMAL(10,2)) Days from tale_1 I get output as 13.09 13.30 31.00 Can anybody let me know how to get rid of the zero after the decimal poin …
1
vote
2answers
24 views

Order by based on case sensitivity

Hello All , Is there any way to sort the column data based on case sensitivity. How can I do order by if I want to display the UPPER CASE data first of same order first and then t …
1
vote
2answers
64 views

Oracle update to teradata update with select subquery

Here is the oracle query .Can anybody give me teradata query . update table_a A set display_format = nvl((select prop.propvalue from table_a B, table_c C …
0
votes
1answer
29 views

Teradata Database Setup errors out for some queries

I have posted the same issue on: http://developer.teradata.com/forum/tools/teradata-database-setup-errors-out-for-some-queries We have installed Teradata on Windows machine. Now o …