Lab Sql

EDIT: Here is a more complete set of code that shows exactly what's going on per the answer be… Read more Writing Efficient Queries In Sas Using Proc Sql With Teradata

Have a value list like` `where a.c1 in ( list ) ` Then shoving the list in the volatile table is t… Read more Optimizing Huge Value List In Teradata Without Volatile Tables

Requirements Single-lines comments (e.g. -- my comment) should be removed. Multi-line comments (e.… Read more Sql/regex Challenge/puzzle: How To Remove Comments From Sql Code (by Using Sql Query)?

I have a problem with a table, I would like to concat a string field using a group by. I have this … Read more Group By Concat Teradata

So I inserted few records in a table manually (without using Stored procedure) and rows were fine u… Read more How To Delete Records From A Column Which Belong To A Different Data Type?

I have three columns Key, x1, y1 1 31 34 2 43 40 3 41 44 4 100 40 My expected … Read more Select Two Values And The Two Values With Which Former Values Have Minimum Distance With

I work in SQL Teradata. I would liek to count how many rows (clients) have rounded value in column … Read more How To Count Rows With Rounded Valus In Sql Teradata?

I have searched the site a bit for a solution to this question but have been unable to find an answ… Read more Count Consecutive Duplicate Values By Group