Stack Overflow
Stack Overflow

Questions tagged [rdbms-agnostic]

For SQL related questions that is not targeted for a specific database product.

Use this tag when asking general SQL questions:
When targeting an unknown ,
or when targeting multiple systems.
(if, for instance, you are looking for a solution that will fit both MySql and ms-access).

33 questions
0
votes
3 answers

Is MAX, MIN, SUM SQL command standard accross diffrent RDBMS

I only have MySQL installed right now but will these work fine when run in PgSQL, MS SQL, etc.? SELECT MAX(field) as max_field FROM table SELECT MIN(field) as max_field FROM table SELECT SUM(field) as max_field FROM table
IMB
  • 15,163
  • 19
  • 82
  • 140
-1
votes
4 answers

What resources will help me understand the fundamentals of Relational Database Design

This are few of the fundamental database questions which has always given me trouble. I have tried using google and wiki but I somehow I miss out on understanding the functionality rather than terminology. If possible would really appreciate if…
Rachel
  • 100,387
  • 116
  • 269
  • 365
-2
votes
1 answer

RDBMS - How to preserve duplicate detection in UNIQUE or PRIMARY KEY column indexes when using semantically secure encryption?

Semantically secure algorithms can create many different ciphertext values for any single plaintext, mostly through the use of a salt or initialization vector. However, that is an obvious issue for detecting duplicate values in a column, as there…
Branko B
  • 1
  • 4
1 2
3