Top "Ansi-sql" questions

SQL query with distinct and sum

I have the following medleys table that combines colors, fruits and ratings: [medleys] medley_id | color | fruit | rating ============================================== 1 red apple 25 2 …

sql sum distinct ansi-sql

What does SQL Select symbol || mean?

What does || do in SQL? SELECT 'a' || ',' || 'b' AS letter

mysql sql oracle ansi-sql

Why isn't SQL ANSI-92 standard better adopted over ANSI-89?

At every company I have worked at, I have found that people are still writing their SQL queries in the …

sql join ansi-sql ansi-92

Someway to do `where booleanvalue=false` on both Sql Server and PostgreSQL?

I am attempting to make an application capable of running on both Sql Server and PostgreSQL. I can not seem …

sql-server postgresql compatibility ansi-sql

In MySQL, should I quote numbers or not?

For example - I create database and a table from cli and insert some data: CREATE DATABASE testdb CHARACTER SET …

mysql sql ansi-sql

Postgres Next/Previous row SQL Query

I have the following table structures in a Postgres 9.1 database but the ideal solution should be DB agnostic if possible: …

sql postgresql ansi-sql

Difference between CURRENT_TIMESTAMP and GETDATE()

What is the difference between CURRENT_TIMESTAMP and GETDATE() in SQL Server? SELECT CURRENT_TIMESTAMP, GETDATE()

sql-server ansi-sql

Using variables in Oracle script

There is a complex query which generates a report. The query has several sub queries that generate 3-columns table for …

sql sql-server oracle plsql ansi-sql

Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?

Is there an ANSI SQL alternative to the MYSQL LIMIT keyword? The LIMIT keyword limits the number of rows returned …

mysql database keyword ansi-sql

Netezza UPDATE from one table to another

This is my query that does not work in Netezza: UPDATE TABLE1 A SET A.COL1= (SELECT DISTINCT B.COL1 …

sql netezza ansi-sql