Timeline for Converting multiple rows to one row
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 10, 2020 at 9:35 | vote | accept | Asrar Ahmad Ehsan | ||
| Aug 10, 2020 at 9:00 | history | tweeted | twitter.com/StackDBAs/status/1292747538425151488 | ||
| Aug 10, 2020 at 8:52 | comment | added | Andriy M | @SMor: Seems to me like a valid option to suggest. Keep in mind that comments can't bring you rep points, but answers can (wink, wink, nudge, nudge). | |
| Aug 9, 2020 at 20:57 | history | became hot network question | |||
| Aug 9, 2020 at 18:55 | answer | added | Akina | timeline score: 6 | |
| Aug 9, 2020 at 18:40 | comment | added | SMor | How is this (ignoring the noted complications) not simply the minimum of the "in" rows and the maximum of the "out" rows with the appropriate group by clause? | |
| Aug 9, 2020 at 15:39 | comment | added | SMor | And what happens when someone comes in before midnight but leaves after midnight? | |
| Aug 9, 2020 at 15:18 | comment | added | NikitaSerbskiy | is it possible that you may have no corresponding Out records for some In records and vice versa? what version of database server do you use? | |
| Aug 9, 2020 at 13:07 | history | edited | Asrar Ahmad Ehsan | CC BY-SA 4.0 |
deleted 58 characters in body
|
| Aug 9, 2020 at 13:01 | history | edited | Asrar Ahmad Ehsan | CC BY-SA 4.0 |
added 154 characters in body
|
| Aug 9, 2020 at 12:55 | history | asked | Asrar Ahmad Ehsan | CC BY-SA 4.0 |