network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 11 months |
| seen | Jan 30 at 8:04 | |
| stats | profile views | 10 |
|
Jun 22 |
comment |
“For each group of results fullfilling condition X, select only result with smallest column value A” Thanks for the info and the link. Unfortunately I find it very hard to search for DB-Related questions, unlike for coding questions. Usually I create my DB-schemas in a way that simple SQL is enough to solve my problems. |
|
Jun 22 |
accepted | “For each group of results fullfilling condition X, select only result with smallest column value A” |
|
Jun 22 |
asked | “For each group of results fullfilling condition X, select only result with smallest column value A” |
|
Jun 22 |
awarded | Scholar |
|
Jun 22 |
accepted | SQL Server: join two tables with “valid-to” dates |
|
Jun 22 |
comment |
SQL Server: join two tables with “valid-to” dates "CROSS APPLY" was the keyword, I didn't know it. The example works like a charm and I could apply it to my problem. I will ask a new related, but different followup question. Thank you very much! |
|
Jun 21 |
awarded | Student |
|
Jun 21 |
asked | SQL Server: join two tables with “valid-to” dates |
