WDrgn's user avatar
WDrgn's user avatar
WDrgn's user avatar
WDrgn
  • Member for 9 years
  • Last seen more than 1 year ago
  • Italy
4 votes
1 answer
24k views

how can I use a CASE with an alias defined befor case?

2 votes
1 answer
8k views

SQL query to get the user, counting the minimum number of records

2 votes
1 answer
864 views

compare 2 tables with minus with a SDO Geometry shape column

2 votes
3 answers
91 views

Generate a list from columns that do not contain a zero for each row

1 vote
1 answer
92 views

Optimize join - group by Oracle SQL filter

1 vote
3 answers
919 views

How can I join two tables of an Oracle database containing all rows (not the intersection)

1 vote
1 answer
107 views

oracle database filter with full outer join and coalesce intersect

1 vote
1 answer
35 views

Matching a column from a table to another table

1 vote
0 answers
45 views

Oracle Table - game like script - need solution to find out the values from current column

1 vote
1 answer
48 views

Oracle database - get two rows (A,B) for every (COD) row

1 vote
1 answer
97 views

Need a sum on my current column

1 vote
1 answer
1k views

Oracle SQL script - passing a parameter

0 votes
1 answer
85 views

Update rows in a table with an index column starting from 0 with consecutive numbers

0 votes
1 answer
505 views

Distinct 3 columns and 4th column with sum [closed]

0 votes
1 answer
65 views

Update an Oracle DB with a max number for the null rows

0 votes
1 answer
49 views

Using group by on several tables with problems [closed]

0 votes
1 answer
47 views

How can I group (by) two joined tables [closed]

0 votes
1 answer
36 views

How can I group two joined tables

0 votes
1 answer
96 views

How to make an union on 2 joined tables without affecting the sum on the column? [closed]

0 votes
0 answers
220 views

Oracle Database - Recursive sum?

0 votes
1 answer
60 views

Connecting 4 tables - finding some differences between them

0 votes
1 answer
58 views

Group-by in an Oracle database

0 votes
1 answer
2k views

oracle database - sql for counting the columns with the same id with the one in current row

0 votes
1 answer
309 views

SQL select with unique_list - losing an item

0 votes
2 answers
3k views

inner join select - group by?

0 votes
1 answer
15 views

Numeric cell with 0 not null

0 votes
1 answer
364 views

Joining Oracle tables with 2 strings to be oa a single row (in a distinct SQL filter)

0 votes
1 answer
4k views

joining tables with full outer join and... COALESCE?

0 votes
1 answer
62 views

How can I get a single row on a inner join not to double my sum

0 votes
3 answers
43 views

I want a select to give me id's that are not in a consecutively order