Top "Ansi-sql" questions

Why does MySQL allow "group by" queries WITHOUT aggregate functions?

Surprise -- this is a perfectly valid query in MySQL: select X, Y from someTable group by X If you …

mysql sql standards-compliance ansi-sql

Oracle proprietary joins- joining on multiple conditions

I've the follwing 2 versions of ANSI compliant SQL(column/table names changed to protect confidential data), of which one of …

sql oracle oracle9i ansi-sql

SQL: aggregate functions with DATE type columns

I stumbled upon a question (in a test) about which aggregate functions are applicable to DATE type columns. So, as …

sql date aggregate-functions ansi-sql

Joining two tables using third as linking table, including null entries

I've looked at a number of similar questions, but have yet to stumble upon/find the correct solution to the …

sql oracle join ansi-sql

How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM?

How do you rewrite expressions containing the standard IS DISTINCT FROM and IS NOT DISTINCT FROM operators in SQL implementations …

sql sql-server tsql sql-server-2008-r2 ansi-sql

Does the order of tables in a join matter, when LEFT (outer) joins are used?

I would like to confirm that the SQL query SELECT .... FROM apples, oranges LEFT JOIN kiwis ON kiwis.orange_id = …

sql postgresql join ansi-sql

Database Engines and ANSI SQL Compliance

I've been searching for half an hour and can't find any resources stating what level of the SQL ANSI standard …

sql database standards ansi-sql

Standard SQL alternative to Oracle DECODE

Is there an ANSI SQL equivalent to Oracle's DECODE function? Oracle's decode function is the IF-THEN-ELSE construct in SQL.

sql oracle ansi-sql

ANSI SQL version of SELECT TOP 1

Is there an ANSI SQL compliant version of SQL SERVER's SELECT TOP n?

sql sql-server ansi-sql

efficient way to compare two tables in bigquery

I am interested in comparing, whether two tables contain the same data. I could do it like this: #standardSQL SELECT …

sql google-bigquery ansi-sql bigquery-standard-sql