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 …