dnoeth's user avatar
dnoeth's user avatar
dnoeth's user avatar
dnoeth
  • Member for 8 years, 9 months
  • Last seen more than a month ago
21 votes
Accepted

Generate and Insert 1 million rows into simple table

11 votes

How to best store a timestamp in PostgreSQL?

11 votes
Accepted

Set non-negative floor for rolling sum, in PostgreSQL

9 votes
Accepted

Grouping based on the status, then count its product and the total based on its category ID

8 votes
Accepted

How can a MySQL delete statement affect a table with over 30 millions records?

8 votes

What's the difference between WITH CTE & WITH CTE (<column_names>)?

7 votes

Summing data based on distinct dates

7 votes
Accepted

Teradata: Select Table With No Lock

6 votes
Accepted

Get first and last record for each date and calculate their difference

6 votes
Accepted

teradata database unable to increase database size in permanent space

6 votes

Combining separate ranges into largest possible contiguous ranges

6 votes
Accepted

How to modify the precision of a datetimeoffset column?

6 votes
Accepted

MySQL Join When Record in Joined Table Does Not Exist

5 votes

Relation Subtraction wrong result

5 votes
Accepted

Inserting rows with WHERE condition

5 votes
Accepted

fill table A with random ID's from another table B

4 votes

Help with removing duplicate reversed pairs in relational algebra

4 votes

Improve a query using cursor to SET Based approach

4 votes

Using the name of an "AS" column in the WHERE clause

4 votes

Teradata 15 : Failure 5619 Role nesting exceeded single-level

4 votes
Accepted

Mysql Data truncation for Valid DECIMAL

3 votes

Boolean check on fields returning any of them except if all have same value

3 votes
Accepted

Ensure order when select two rows using two identifiers on the same column

3 votes

Get all orders that are "ordered" but not "paid"

3 votes

How do I get a list of all the partitioned tables and partitioning details in my Teradata?

3 votes
Accepted

Query optimization in case of TIMESTAMPDIFF

3 votes
Accepted

SQL Syntax Error - Unsure if it is empty value or backslash

3 votes

Teradata Join Syntax

3 votes

Extract MIN and MAX values related to datetime values on Postgres 9+

3 votes

Unique identifiers for the same type of object in the same request

1
2 3 4 5