Top "Teradata" questions

Teradata is a Relational Database Management System (RDBMS), capable of supporting many concurrent users from various client platforms.

What is Teradata's equivalent for Oracle's DUAL

In Oracle, we can write this to generate a single row using a SELECT statement. SELECT 1 AS x FROM dual …

sql teradata dual-table
Maven dependency for Teradata JDBC driver

Does Teradata have its JDBC driver uploaded as a jar referenced from a maven file?

maven jdbc dependency-management teradata
what is the full Teradata Client software?

I read couple of online documents to get start with the Teradata basics. I am curious to know what is …

teradata
Sample of data within groups - Teradata

Found a similar question but without an answer that worked succuessfully. I need to select a sample of 50 of each …

sql teradata sample-data
How to calculate moving sum with reset based on condition in teradata SQL?

I have this data and I want to sum the field USAGE_FLAG but reset when it drops to 0 or …

sql sum teradata
Why subquery does not work in teradata?

I tried this SELECT * FROM ( SELECT * FROM mytable; ); and this SELECT * FROM ( SELECT * FROM mytable ); Why these simple queries do …

sql teradata
Case statement with Ranking function

Hello looking for help with ranking. I'm working with Teradata using SQL and I'm trying to rank a list by …

sql teradata ranking ranking-functions
Teradata - limiting the results using TOP

I am trying to fetch a huge set of records from Teradata using JDBC. And I need to break this …

sql teradata
View vs volatile table?

What is the difference between a view and a volatile table in Teradata? As far as I know, a volatile …

teradata
Difference between Qualify and Having

Can someone please explain me, what is the difference between qualify...over...partition by and group by...having in Teradata?…

teradata