user avatar
user avatar
user avatar
stefan
  • Member for 5 years, 3 months
  • Last seen more than a month ago
  • Scotland, United Kingdom
8 votes
Accepted

How to add a named constraint in Oracle SQL?

8 votes
Accepted

What is a "PARTITIONED OUTER JOIN"?

4 votes
Accepted

How to name a constraint which was unnamed during the table creation?

4 votes

Referential integrity when two FK columns need to match themselves in the same table?

4 votes

why different where condition got the same select results?

4 votes
Accepted

How to select unique records in PostgreSQL without using Distinct clause

4 votes

Multi-field unique constraint where we include one or another field based on nullity

4 votes
Accepted

Select Case Query

4 votes

NULL values in unique constraints

3 votes

MySQL: SELECT with SUM() and COUNT() as new columns

3 votes
Accepted

How to format String with a pattern

3 votes

Not able to create this table

3 votes

MySQL permits setting a foreign key constraint that references only one column of a composite primary key

3 votes

Mutually exclusive many-to-many relationships

3 votes
Accepted

Select a CSV string as multiple columns

3 votes
Accepted

Group values: CASE text, ELSE field value

3 votes
Accepted

Use An Aggregate With Computed Column

3 votes

Calculate percent of roads (by length) where condition is >=15

3 votes

Retrieve a count from a one-to-many relationship even if there are no rows at the "many"-end of the relationship

2 votes

Unique triplets from pairs

2 votes
Accepted

Problem with BETWEEN and SUM

2 votes

Select those entries where the relationship of the columns f1:f2:f3 is roughly number1:number2:number3

2 votes

Foreign Key as Primary Key when "converting" conceptual entity-relationship elements to logical relations

2 votes

OUTER JOIN Works in one direction but not the other

2 votes
Accepted

Select one row from n number table; Join / Union table with looping

2 votes

Is a composite key correct here?

2 votes

Compare words in a string without considering their positions?

2 votes

Creating a database for students

2 votes

PostgreSQL: how can I shorten a multi-word string to few words?

2 votes

postgreSQL how can I make this work with an aggregation alias?