Stack Overflow
Stack Overflow

Questions tagged [ansi-sql-92]

35 questions
1799
votes
27 answers

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (MySQL, Oracle, SQL Server,…
Claude Houle
  • 41,064
  • 8
  • 33
  • 42
11
votes
5 answers

Pattern matching SQL on first 5 characters

I'm thinking about a SQL query that returns me all entries from a column whose first 5 characters match. Any ideas? I'm thinking about entries where ANY first 5 characters match, not specific ones. E.g. HelloA HelloB ThereC ThereD Something would…
MJP
  • 5,327
  • 6
  • 18
  • 18
6
votes
2 answers

Does the SQL type TIME WITH TIMEZONE make sense?

While doing the mapping of some database columns into Java classes I stumbled onto this obscure SQL-92 Standard type (implemented by PostgreSQL, H2, and HyperSQL afaik). I haven't ever used it, but I wanted to understand how clearly map it to a Java…
The Impaler
  • 45,731
  • 9
  • 39
  • 76
4
votes
1 answer

Is CURRENT_TIMESTAMP a function in ANSI SQL?

I was using the bigquery function current_timestamp() when i discovered that you can use it without parenthesis if you want. Since it is a function, i would advocate for parenthesis, but what i find on the internet indicates that you can indeed use…
Amaury Faure
  • 43
  • 2
4
votes
2 answers

Does Oracle 10g comply with the ANSI SQL-1992 substring function standard?

According to the ANSI SQL-1992 standard, page 132, this is the syntax for the ANSI substring function: ::= SUBSTRING FROM FOR ]
JavaRocky
  • 19,203
  • 31
  • 89
  • 110
4
votes
2 answers

ANSI SQL standard for ORACLE MINUS keyword

I have Query which i want to ANSI SQL standard compatible . In this oracle query MINUS key work is used and i want to ANSI SQL which is placed for MINUS keyword SELECT 'F' selected, UPPER (( a.business || ' ' …
Jack
  • 253
  • 3
  • 8
3
votes
1 answer

How to Select value By SuiteQL That I can filter Multiple Select Field

I had one simple table ItemMapping, 2 Field, one Field is single Item List Field SingleSelectField With value "A", Other for Multiple Item List Field MultiSelectField with Value ("B", "C", "D"). I Wanna get This mapping relationship By "B", I tried…
Tyrion Huang
  • 71
  • 1
  • 12
3
votes
2 answers

ANSI 92 Recursive SQL Statement required

I am translating SQL Server SQL Statements into their ANSI generic equivalent at present, and am stuck with a recursive statement using a WITH statement. For the sake of concentrating on the issue, I'll simplify the issue as follows If I have two…
johnc
  • 39,385
  • 37
  • 101
  • 139
3
votes
1 answer

Which databases support BATCH INSERT syntax?

I know, MySQL supports BATCH INSERT syntax like: INSERT INTO `table_1` values(1, 2, 3), (3, 4, 5), (5, 6, 7); Is this syntax included in SQL-92 format? If not, witch data bases support this syntax?
user2602807
  • 1,232
  • 2
  • 15
  • 28
3
votes
2 answers

Get message in MQ QUEUE with JMSTIMESTAMP

I have a problem when i try to get message with put date/time beetween two dates (beginDate and endDate). Here is my query receiveSelected("JMSTimestamp BETWEEN " + pBeginDate + "AND " + pEndDate). A message is in the queue and the timestamp is…
Gorgui Ndong
  • 153
  • 1
  • 10
2
votes
1 answer

Requesting help on how to group the counts of multiple conditions in one query

I need to count the number of subscribers whose effective dates precede the end dates of months and whose termination dates proceed the first date months within a given timeframe. I then need to group those results in a report formatted by year and…
user11429425
2
votes
2 answers

Select a row by max(year) and group by name, but also include other values in the result set

i have a problem with a specific selection in a table. In would like to find all Persons grouped by Name with the max year. But I need also the other columns, for a later join, in the result set. Furthermore, the id is unordered, so it can not be…
Andreas Hauschild
  • 528
  • 4
  • 17
2
votes
1 answer

Escaping colon in JMS Selector - Apache ActiveMQ Apollo

I am using Apache Apollo -1.1 as my JMS broker. Within that, I am trying to use a selector on a JMS Header, which contains colon in the value. The JMS header is as follows: SYMBOL=USDGBP17MAYFUT::CDE When I try to use the message…
Varun Paliwal
  • 35
  • 6
2
votes
0 answers

IN and ANY not working as expected in H2 (with examples)

EDIT: This appears to be a bug in H2 version 1.4.190. I have updated my post below. The problem does not happen in version 1.3.176 or 1.4.191. (Suggestions for optimizing the queries also welcome) Consider the following table with data: CREATE…
Jus12
  • 17,824
  • 28
  • 99
  • 157
2
votes
0 answers

Mysql dump to SQL-92

I have a http://www.product-open-data.com/download/ POD Database - dump and it's MySQL dump. What I need for Virtuoso Sponger is SQL-92 dump is there any way to convert it automaticaly to SQL-92. It would help me a lot. I can't imagine rewriting 2,6…
Buteo Mausjäger
  • 123
  • 1
  • 11
1
2 3