Popular "ansi-sql" questions | Page 3

On the Wikipedia page for SQL there are some truth tables about boolean logic in SQL. [1] The Wikipedia page seems …

sql null boolean-logic ansi-sql

I need a way to determine the number of days between two dates in SQL. Answer must be in ANSI …

sql date date-arithmetic ansi-sql

Is it allowed to cast types in ANSI SQL like in postgres for example: SELECT SUM( CAST(qnty AS int) …

sql casting ansi-sql

I am writing a simple data warehouse that will allow me to query the table to observe periodic (say weekly) …

sql data-warehouse ansi-sql

Small working example SELECT SPLIT("hello::hej::hallo::hoi", "::") returns an array [hello, hej, hallo, hoi] where I want to …

sql google-bigquery ansi-sql

I am trying to find the ANSI way to write the T-SQL 'IS NULL'. (corrected, was 'IN NULL') Some posts …

sql coalesce isnull ansi-sql

I have MySQL and the query is: select name,re_type from myTable I want to replace all values of …

mysql sql case-when ansi-sql

I have a table tb_FirstName with one field FirstName. The table has 100 million non null records with lots of …

sql sql-server standards ansi-sql

I am wondering if there is a method to implement SQL analytic functions without using the inbuilt functions. SELECT *, ROW_…

sql ansi-sql

ANSI-92 SQL mandates that comparisons with NULL evaluate to "falsy," eg: SELECT * FROM table WHERE field = NULL SELECT * FROM table …

sql null ansi-sql

Top "Ansi-sql" questions