Programming Language
Abap
ActionScript
Assembly
BASIC
C
C#
C++
Clojure
Cobol
CSS
Dart
Delphi
Elixir
Erlang
F#
Fortran
Go
Groovy
Haskell
Html
Java
Javascript
Julia
Kotlin
Lisp
Lua
Matlab
Objective-C
Pascal
Perl
PHP
Prolog
Python
R
Ruby
Rust
Scala
Scheme
Shell/Bash
SQL
Swift
TypeScript
VBA
Framework
AngularJS
Backbone
Bootstrap CSS
Bootstrap Javascript
Bulma
CakePHP
CodeIgniter
Django
Drupal
Ember
Express
Flask
Flutter
Foundation
Ionic
jQuery
Laravel
Materialize
Next.js
Node.js
Nuxt.js
React
Semantic UI
Spring
Symfony
Unity
Vaadin
Vue
Wordpress
Yii
Zend
Categories
Tags
Ansi-sql
New post in Ansi-sql
ANSI SQL version of SELECT TOP 1
September 15th, 2022
ansi-sql
sql
sql-server
SQL: aggregate functions with DATE type columns
June 25th, 2022
date
ansi-sql
aggregate-functions
sql
MySQL replace result value with another value
June 17th, 2022
case-when
ansi-sql
sql
mysql
Ansi SQL type casting
August 10th, 2022
sql
casting
ansi-sql
BigQuery Standard SQL: how to return the first value of array?
June 16th, 2022
ansi-sql
sql
google-bigquery
Implement Rank without using analytic function
July 3rd, 2022
sql
ansi-sql
Standard SQL alternative to Oracle DECODE
June 12th, 2022
oracle
ansi-sql
sql
Netezza UPDATE from one table to another
August 20th, 2020
netezza
sql
ansi-sql
Someway to do `where booleanvalue=false` on both Sql Server and PostgreSQL?
July 9th, 2022
compatibility
sql-server
postgresql
ansi-sql
Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
October 24th, 2020
database
mysql
ansi-sql
keyword
Difference between CURRENT_TIMESTAMP and GETDATE()
July 9th, 2022
sql-server
ansi-sql
ANSI SQL Manual
August 17th, 2020
sql
reference
manual
ansi-sql
What does SQL Select symbol || mean?
June 28th, 2020
ansi-sql
oracle
sql
mysql
How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM?
July 8th, 2022
tsql
ansi-sql
sql
sql-server
sql-server-2008-r2
Why isn't SQL ANSI-92 standard better adopted over ANSI-89?
July 8th, 2022
sql
ansi-sql
join
ansi-92
SQL query with distinct and sum
July 18th, 2022
ansi-sql
sql
sum
distinct
Why does MySQL allow "group by" queries WITHOUT aggregate functions?
July 5th, 2022
mysql
ansi-sql
standards-compliance
sql
ANSI equivalent of IS NULL
June 14th, 2022
sql
ansi-sql
isnull
coalesce
Standard SQL boolean operator IS vs. equals (=) operator
June 4th, 2022
null
ansi-sql
boolean-logic
sql
How to write these two queries for a simple data warehouse, using ANSI SQL?
June 4th, 2022
sql
ansi-sql
data-warehouse
Joining two tables using third as linking table, including null entries
June 17th, 2022
ansi-sql
join
sql
oracle
Number of days between two dates - ANSI SQL
June 12th, 2022
ansi-sql
sql
date
date-arithmetic
Select 1000 distinct names from 100 million records via standard sql
June 5th, 2022
standards
sql-server
sql
ansi-sql
Database Engines and ANSI SQL Compliance
May 2nd, 2022
standards
sql
ansi-sql
database
Why do I need to explicitly specify all columns in a SQL "GROUP BY" clause - why not "GROUP BY *"?
April 21st, 2022
ansi-sql
sql
sql-standards
group-by
aggregate