Skip to main content
Marco's user avatar
Marco's user avatar
Marco's user avatar
Marco
  • Member for 9 years, 1 month
  • Last seen more than a month ago
26 votes
Accepted

If positive, sum all items. If negative, return each one

12 votes
Accepted

Using Two LEFT JOIN or use AND with single LEFT JOIN?

11 votes
Accepted

Creating 7 digit codes in database for every new insertion

8 votes

Postgresql Log "^M" Meaning

7 votes
Accepted

Use only one Junction Table per Database?

6 votes

UNION query question

6 votes
Accepted

single table to reduce joint queries?

6 votes

How to identify a user (Oracle) that is locked due to unsuccessful login attempts

5 votes
Accepted

Am I doing a security breach if I am connecting a MS-Access front end (multiple computers) to a SQL Server back-end?

4 votes
Accepted

Calculating a percentage discount in SQL

4 votes
Accepted

Proper use of array in table? Multiple elements of the same field and record

4 votes

Creating a index on a date column that's already populated

4 votes

Why does this query work?

4 votes

Using postgres database from another computer

4 votes
Accepted

Oracle SQL. Error creating type

4 votes
Accepted

Query keeps on giving me 'unknown column' issue

3 votes
Accepted

How to create a table with data from other tables in Postgres?

3 votes
Accepted

Inserting two tables together with no Id or UNIQUE anything

3 votes

ORA-01950 error during the execution of insert statement

3 votes

will there be any issue for my system if I upgrade my database which is oracle 11.1.0.6 to 11.1.0.7

3 votes

Number of sessions connected to database

3 votes
Accepted

Migration of records to the table with different column names

3 votes

Do I need to create tablespace and also add all datafiles before importing a schema using datapump?

3 votes

Oracle: Mutually modifying two tables?

3 votes
Accepted

Oracle - restore a single table

3 votes
Accepted

Can't create user in postgres

3 votes
Accepted

Combining two similar queries into one (PostgreSQL)

2 votes
Accepted

SQL Data warehouse and normalization forms

2 votes
Accepted

Sql tables design

2 votes

UPDATE only if COUNT from another table is not zero

1
2 3 4 5 6