Questions tagged [ansi-92]
8 questions
113
votes
16 answers
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 ANSI-89 standard:
select a.id, b.id, b.address_1
from person a, address b
where a.id = b.id
rather than the ANSI-92 standard:
select a.id, b.id,…
Patrick Harrington
- 47,416
- 5
- 23
- 20
5
votes
3 answers
List of common SQL queries for Open Source databases?
I'm trying to find information about the correct RDBMS SQL queries for open source databases like MySQL, PostgreSQL, SQLite, and others. Are their any pre-assembled lists out there or do I just need to comb the documentation for each database engine…
Xeoncross
- 55,620
- 80
- 262
- 364
4
votes
2 answers
Ensure SQL-92 on Access 2000 mdb to SQL Server under Access 2010
Due to circumstances not fully under my control, I have to develop ACCESS queries which will be stored in an Access 2000 MDB but which may be developed under any one of: Access 2000, 2002, 2003, 2007, 2010. These queries will access (via linked…
PaoloFCantoni
- 967
- 2
- 12
- 26
3
votes
2 answers
Joins in Oracle: Which field on which side of an = sign?
When joining tables with either the ANSI-89 (old) or the ANSI-92 ("new") method of joining tables, does it matter which side you place the fields from the 2 joining tables.
For example, is it better to do:
From
TABLE_1 A
Join
TABLE_2 B
on A.ID…
Phillip
- 447
- 1
- 4
- 12
2
votes
1 answer
SQL-92 Query to find earliest date dependent on column value changing
I am querying a data system with an OLEDB interface that supports SQL92. My query problem is equivalent to the one solved here: SQL Query to find earliest date dependent on column value changing,
but the solution provided there and copied below is…
user283878
0
votes
4 answers
Are the following select statements SQL92 compliant?
Are the following select statements SQL92 compliant?
SELECT table1.id, table2.id,*
FROM table1, table2
WHERE table1.id = table2.id
SELECT table1.Num, table2.id,*
FROM table1, table2
WHERE table1.Num = table2.id
Rossini
- 5,960
- 4
- 29
- 32
0
votes
1 answer
delete first X row Ingres ANSI
I have 730000+ records which I need to delete in Ingres db which work with ANSI92 and I need to delete then without overload db, simple delete where search condition, doesn't work, DB just use all memory and trowing error. thinking to run it …
Andrey
- 1,629
- 13
- 37
- 65
0
votes
1 answer
Time difference returning integer ansi sql 92
I am trying to calculate the number of minutes between two datetimes using sql ansi-92. I'm not able to use timestampdiff() function because I get an error response.
I tried date1-date2, but I always get a result of 0 (although no error).
Example:…
chris
- 1
- 2